In the context of 'gaming' systems with all components sharing a chassis with top-end GPUs blazing out ~400W sustained, passive cooling isn't really practical.
But yes, for a general-purpose machine, silent (fanless) running has been a solved problem for a while now.
...build a computer with zero moving parts