In my experience, having sold more than 1000 watercooling AIOs, I will never recommend watercooling for silence or reliability. For that, always go premium air cooling.
Not saying that you cant find watercooling AIOs that will give lower temps than air, but a good AIO will cost more than premium air and the reward doesnt justify the extra cost.