Ok I've had a breakthrough and thanks to posts from
artsip and
Kensuke I'm making progress with an annoying sound.
We all know that the buzzing sound is coil whine and we're familiar with how that sounds.
But there is another annoying sound, it's a very high pitched sound, an annoying resonance.
I posted a sound clip of my console here
https://voca.ro/1fM2Omb9QSN7.
Can you hear that high pitched sound? I can hear that from 10ft away, and when the console is in active standby mode.
It turns out the cause of the sound is the metal plate of the fan vibrating against two black holders which causes that sound.
To fix it you either need sound dampening o-rings, similar to what you would use on a HDD or experiment with loosening the fan screws.
I can deal with the coil whine but honestly that fan vibration sound pierces through my skull.
If anyone else is suffering from the same sound there is hope.....
Here is a video demonstrating how the noise stops once the fan no longer makes contact with the black contact points
And here is an unconventional fix with sponge lol
No I posted it as a joke. It's literally the sound from a jet engine.