Granted, I never had any insanely beastly machines, generally just sub-$1500 gaming rigs. The only sounds that I ever even noticed were shorter irregular ones, like spinning disks. Perhaps the problem is simply more noticeable to other people, especially those with more powerful and thus louder machines, or people with smaller spaces who have their machines much closer, like on their desk or around their feet.
I care about ambient noise much more for other applications, like laptops or home theater PCs. For both of those, I have a strong preference for fanless models if at all possible.
The trash can Mac Pro seemed to be designed to sit on a desk, so quietness makes sense, although I don’t understand what’s so important about having very powerful machines on your desk. For machines like iMacs, the problem of placement is obviously unavoidable, but I struggle to understand why that form factor is desirable for a very powerful machine.
I have routinely been building nearly silent 99% maxed out gaming/vr rigs with integrated off the shelf liquid cooling units with no tubing or scary liquid interactions needed.
You've never seen the rig of a competent PC modder before that? "Dead silent computers" were pretty much invented by those people.
Apropos, here these old Powermacs still fetch a nice price, because their cases are valued by modders for ATX conversions.
Until the Mac Pro I hadn't considered that a modern, high power computer could also be dead silent. It's stupid, but that was a revelation for me. I couldn't even tell it was turned on or not, except from the occasional hard drive seeking noise - which I fixed with an SSD. And 7 years later it still is as silent.
Unfortunately Apple is now focusing on keyboards with no depth and whatnot, so I'm back to building my own but I do keep in mind the lessons. My system now has 10 fans + 1 PSU fan, all running between 700-900rpm. I can hear myself think again.