Well I had 2 Corsair SF600 Gold PSU, 1 Corsair SF450 Gold. Basically they tend to be pretty noisy in warm environnement. Corsair is using BS 92mm fan inside their SFX PSU...that could be really loud.
Fan on Corsair SFX PSU are starting/stopping following load OR internal temperature.
Basically everytime I was launching a game, SF600 fan start spinning, quite fast & noisy...but while gaming, it's ok. However when I was shutting down game, SFX PSU fan is still spinning (almost forever) fast & noisy while on idle...so very very distracting & annoying!
However I found best mod (really easy one) : replace psu fan by Noctua NF-A9x14 PWM (spinning around 1000 rpm)
Since this mod, SF600 is just running smoothly and silently..
Plenty of of SF series psu also did this mod.
After on SFX-L size, I love my SX800-LTI...as you have a true fanless mod, only related to load. Above 160w load, fan is starting to spin...and it's going back to sleep once load is over.