Do the good compilers such as GCC exploit multiple cores? I’m aware of the make -j good thing.
I consider clang my favourite compiler, but usually yes.
Sometimes certain software when compiled is single core only, and it can be forced with -j but if you do so it fails due to out of order compilation, but most modern stuff will utilise whatever cores you allow it to. So compiling typically loves lots of cores. Also not just for compile speed but also to keep rest of system responsive whilst compiling.
Best system for desktop is a weird one given intel's new cpu's.
I would says the AMD 5000 series, £1500 for that assuming you dont want high end GPU can get the cpu already suggested 5950x or at least the 5900x.
The Intel Alder Lake platform has nice potential, but because of the big/small architecture I consider it too early, it has scheduling issues on windows, it has issues with denuvo DRM, and its unknown how well it works on Linux and BSD currently, but I expect not optimal until new schedulers are made. Its big cores do win on performance per core though vs AMD 5000 series.