I generally dont really find noise from fans annoying. You can pretty much lower the RPM at idle in most motherboards. If I am gaming at full load the loudest part is the graphics card anyway.
However at idle the high pitch noise from electric component or in some cases, the pump noise for AIO...