I run a pretty-much-fanless Arch Linux desktop. It’s a Lenovo m920q I bought second hand, ex lease on eBay. Super simple, no fuss at all. Comes with remote KVM in the motherboard. (The security implications are totally probably fine)

It’s totally silent in normal use. (Go web dev mostly)

Occasionally the fans will start up to alert me to the fact that I’ve landed on some social scummy website that’s crammed with 20 banner ads on the one page and is probably trying to mine something in the background as well. I shut that browser tab and the noise goes away.