Huh, didn't realize this was such a widespread problem. I seemingly got very lucky with mine, it's very quiet.
I had an ABSURDLY loud disc drive at first but noticed it was the top face plate doing the noise from disc drive vibration during installation. Once I took off the plate and put it back on properly, the absurd noise disappeared. It was apparently a tiny bit loose from transit and that was the problem. Now I only get regular drive noise whenever I install games and occasionally when the hourly verification happens or whatever it is.
My console has some ever slight coil whine I can hear when I mute my TV, but as long as I'm playing at regular volumes either through TV or headphones, I can't hear a single bit of the console. And I sit only ~1.5m away from my TV. The fan is barely noticeable, I have to hold my ear right next to the console to hear it. Such a great experience coming from a turbo jet engine PS4 Pro. I really hope my console stays this quiet and I hope people who have loud consoles somehow will be able to get a replacement or whatever fix Sony comes up with.