I think that the 'to-full-rpm-or-not-to-full-rpm" is a bit of a double-edged sword to be honest in the case of the Zalman. Sure, the cooler soes a superb job of keeping the CPU cool at 800rpm, but for me there's an added benefit of running it at high RPM. If I keep my Zalman at low speeds, then the northbridge fan on my DFI nF4 Ultra-D tends to ramp right up when I'm playing games like EQ2 or HL2. However, if I run my Zalman at about 2000rpm then the northbridge and RAM get the benefit of a wee bit extra cooling and as such the moerthbridge fan isn't howling like a beast
And yeah, I run 3 fans to ensure a nice flow of air through my case. The Zalman just adds a bit more that seems to make a good bit of difference.
Just my £0.02 worth.