Well, I have a Q9400, currently cooled by a
Zalman CNPS 9500A LED And at 3.6Ghz it tops out at 45-50c at OCCT load and if I leave it at stock doesn't go past 40c.
Anyway, sources of noise can come from everywhere, for example I had a 80mm case fan pointing at my CPU (Which was fine with a Gigabyte NeonCooler 775). The moment I installed this new HSF, the fan became loud as hell because of the change of airflow. It is now set as an exhaust fan, it is much quieter and cooling has not been compromised.
Basically, fan noise varies from case to case, cooling system to cooling system and change of components can affect others, so you need to literally go by ear to source the point of noise.
Also, use
EVGA Precision to control your GPU fan speed, you'll notice the difference.
Edit: On that note my PC is as quiet as it has ever been (with 7 fans in total spinning away!), and is still mighty cool even when overclocked. I think I have at least 12 months now where I actually do not need to replace a single component, I am happy!
More edit: That Asus Lion Sqaure got a pretty average review at
Frostytech, maybe you should consider an alternative.