Certainly power supplies generate noise. But the PSU has never been the focus of my noise-reduction efforts.
There is a cumulative vibration of components transmitted through the case: CPU fan through heatsink, motherboard, standoffs -- to the case; fans through their mountings to the case; hard disks through the cages through the case. Somebody is going to sneer at me for this, but I'm satisfied I've been able to reduce vibration from the PSU with a silly-cone grommet where it bolts onto the case.
My ALLIED AL-B500E doesn't seem to have noisy fans, but it is a modestly priced, modestly featured PSU.