Depends in what your looking for! Like anything else, there's trade-offs. You narrowed it down by species. But even within that, for trout, are we talkin mountain stream brookies, flat water limestoners, or steelhead here?
Softer materials combat drag better. But they cast worse, soak up water more, and are often less abrasion resistant. They also tend to wind knot and twist more.
There's other trade offs too, like stretch. Stretch is often seen as bad, but in my experience, it's good, as it acts as a shock absorber when fighting big fish, as well as keeps me from oversetting the hook!
Soft vs. stiff is real easy to test. Get tippet from various brands. Mic it, don't trust the diameter on the spool. Cut off equal lengths at the same diameter from different brands. Clamp them in a vice at the same spot. Play and observe.
How "low" does it hang on it's own? Then start playing around with it. Compress it, push it to the sides, etc. There's bigger differences in stiffness than you would anticipate!
Personally, I like softer materials for most of my fishing. Drag is my #1 enemy. I'll take the trade offs to better handle that one. Rio Powerflex is very good, Rio Suppleflex, if you can find it, is a touch better. There is some overlap, but generally, copolymers are the softest, flourocarbons are stiffer, and straight (single strand) mono's are stiffer yet. Unfortunately, we have a tendency to call copolymers "mono".
That said, that's the business end. I like stiffer materials for the butt section of my leaders. Maxima Chameleon is about as stiff as they get, a single strand mono. And to ease the transition between stiff and soft, it's good to have a length or two of a tweener in the mid section of the leader.