I do entirely agree with that, the intake trumps. There's still plenty of options out there that are inexpensive and have dual 120s anyways. One positive thing that has changed is that hard drive temps seem to have really dropped in the past 10 years. I'm not sure how much heat SSDs generate in comparison but their smaller size seems to make them easier to cool.
Playing around with different cases in the past that do days worth of highly threaded complex geometry processing gave us a decent idea of do's and don'ts for certain configurations. Yeah some of the more important systems were server room, but not all.
It really depends on where and how you do it. For example, if you have a wide open case with a couple exhaust fans, that will be less effective because the air flow is taking the path of least resistance, which is not through your heatsinks (therefore, not properly cooling anything). In a situation like that, intake fans are better because it forces the air in, and lets it seep out on its own.
But if you have a sort of duct system (or in other words, a much more linear path of air flow) then there isn't much of a difference when doing just exhaust fans, except for noise. I have a FX-6300 at 4.4GHz and under 100% load my temperature doesn't exceed 55C. This is air cooled with only a heatsink fan and an exhaust fan, but you can REALLY feel the heat spewing out the back. If the CPU is idle and I crank up the fans, the temperature drops to as low as 16C. Not bad for a $60 computer case and a $25 heatsink.