A lot of it also depends on how much time and energy was put into airflow management. I am slow to put a lot of extra cooling into a computer built by a retailer because many of them custom-build their cases and take airflow into account. For instance, we have some older Dell Optiplex machines at work which have a plastic cover over the CPU heat sink that channels air towards a fan that blows air out of the case. What happens in a lot of home-built computers is that people put big, bulky cards into their machine that disrupts airflow and they do not put their cooling fans in the right places.Originally posted by Mr Sleep
I recall reading, (could find the article if you want) that too many cooling fans can actually stifle the movement of air through ones machine, it is better to have one more powerful cooler than two. I don't have one at the mo, so this is just second hand knowledge.
Other times, people will orient all of the fans in their computer to blow air out of the computer thinking that they are doing the machine a favour by expelling all of the heated air coming off of the CPU, the video card and the hard drive. What they forget is that there has to be some mechanism for cool, fresh air to come in to the case, just as your car is made so that cool air flows over your radiator to cool off the engine block. I've read that it's actually better to pick a direction you want the air to flow (front to back or back to front) and make sure that all of your fans are blowing in the same direction.
One other thing I've seen (but never used) is hard drive coolers that attach to the screw-points under a hard drive and blow cool air on to the hard drive. I think these may be the kinds of fans that do more damage than good by altering the airflow within the case. I also think that if you're working your hard drive so much that it needs its own cooling mechanism, you have larger cooling issues than just bolting a couple of fans to it.
Unless you're going to subject the guts of your computer to wind tunnel tests, I am of the opinion that you can never put too many cooling fans in a case, but you need to have some plan for air flow both inside the case and in terms of moving hot air out and pushing cool air in.