I have a Corsair "RAM Cooler" and have yet to have a need for it. Though I've used it on both DDR2 & 3 RAM, It's currently sitting in my parts bin, away from my overclocked system
As for noise, I can't say it was any louder than the other fans in my system.
My two cents.