Hi Faelannm,
To an extent - it depends on what you want to use the PC for … 
I used to build all my own machines, looking over into the corner of the room I have half a dozen or more 1U and 2U rackmounts and 3-4 old servers, all home built circa 2010-2016. None of which are in use any more, but all of which served their time.
Why they’re no longer used … primary power consumption (and noise). They all tend to draw 90+W when idle and up to 180W when busy. There are calculations elsewhere on the forums but typically this runs into a three figure annual bill, per machine. (at today’s power prices)
I run one machine now as a server, and have one on standby, both are lower power ASUS motherboards with Ryzen 5000 chips. Generally I favor ASUS in terms of compatibility, I think 90% of my older stuff is also ASUS based on AMD Chips, Phenom II and Phenom III, so old 4-core and 6-core units.
Prior to that I also used to use ASUS bare-bones units … none of the ASUS kit historically tended to have any compatibility issues I was aware of.
GPU’s are a bit of a minefield, again, depends on your use-case. I tend to use dual-head Nvidia clones which are fan-less, cost about £30 and support 2x4k screens. Probably not so great for gaming, but fine for development and YouTube.
So overall, if you’re new to this or out of practice, I’d look at an ASUS bare-bones unit (i.e. just add RAM and a CPU) and you probably can’t go too far wrong. For a full build, AMD CPU, ASUS Board, Nvidia cards generally tend to work well despite some of the negative press. Also, use the ‘real’ driver, the Open Source Nouveau is Ok but you’ll miss out on some subtle / desirable features.
Now …
I run one old PC as a server, all the rest of my machines are Raspberry Pi’s. Mostly 8Gb 5’s, but with a couple of 4’s. My Workstation is a RPi5, I get flawless 1080p playback with two 4k screens up.
This may not suit if you’re a gamer, but for everything else … mine are all clustered with services running in containers, which makes it pretty resilient, cheap, and very low power. (~ 5W/machine) I can migrate services around the network, notably containers work happily on RPi4’s and 5’s, i.e. the two are completely compatible at a Linux container level. (it’s just a speed difference)
Linux compatibility is 100% as far I’m aware. Out of the box you get 1G network, bluetooth, WiFi etc … I run M2 extensions so I’m getting close to 1G/sec M2 storage, and you can now have up to 16G RAM. (and it has full support for booting and running of USB storage and SD cards) I think 8G boards are now ~ £75. Tenner for a power supply, then just add some storage, £6 for an SD card gets you going. Maybe add a case for another tenner.
And of course you no longer need any boot medium, plug it into a network connection cold and it’ll boot and install Debian directly off the net.
hth