I’m tempted by a desktop but I worry about noise. Typically power components == big cooling reqs == big fans == big noise. There are specialized vendors who guarantee quiet but obviously they cost more.
Granted, my high end gaming machine can get a bit noisier compared to my macbook, but even then the kind of noise is more pleasant than the relatively high pitched wind coming out of the MBP. The 3900X and the GPU do generate a ton of great though, so the focus is not on noise and heat output like in your case.
Older generations [of the hardware!] have more stable Linux support. I currently have a gen 4 Intel NUC (Haswell) and it is a lovely platform.
Not a lot of local compute power though. For that, it seems better to go all-in on well cooled datacentre hardware and connect to it remotely.