Can get an idea of the noise from the Aero @ 5:45 into this video:
See if you can find a similar sound test with the Gigabyte and the two fan model you're looking at.
Also, undervolting (while still overclocking) is a very good thing, especially in tight cases with little airflow. Can really reduce the heat and noise.