As a rule, yes, stiffer shafts produce more accurate results, while whippier shafts produce distance.

Now, those are the conventional standpoints. I'm starting to wonder if it has more to do with proprioception and how a player releases the club vs raw flex.