it all depends WHAT you are running... if you are running an old 90 MHZ Pentium 1, you'd be stupid for wasting your time with a case fan, let alone a processor fan.
If you're running any "modern" processor, it'd be a good idea to have at least one fan blowing air out.
Think about this, if you have a Processor fan that's just blowing the same heated air on the heatsink, eventually the air is going to reach a temperature close to the CPU temp, then it's not doing much for cooling, and as a side effect, everything else inside your case will get hot. Then throw in the fact that everything else will be making it's own heat to begin with.
I would, go pick up a couple of stealths or panflos, something nice and quiet. The little noise they make will be drowned out by your processor fan anyway. If it's that much of a bother you should really consider some alternate silencing methods, such as foam/dynamat, rubber washers and grommets on everything, bondo any useless holes, etc.