AMD traditionally offers more power for less money and you can also fiddle with it a lot. I destroyed multiple AMD processors. There are just more tools to mess with AMD and it is so much fun. They advanced a lot in reliability.
As others have pointed out, it is much more complicated.
If you want to minimize cost, it mostly depends on your energy cost. If it is low it doesn’t matter since all CPUs will gladly last 10 years or more. If it is high, go for the one with the least power usage overall (if 24/7 workload) or least idle power usage (if idling a lot).
If you want to put it in your bedroom you also want one with not so much heat output probably since it will be easier to cool = quieter.
If you need to do processing or Virtualization you want multiple cores. If you do IO intensive tasks you need lots of PCIe and probably high clock speeds … etc etc
So what are you trying to optimize for?
ARM or RISC-V.
Apple makes some very nice ARM machines. If you’re running Windows, see https://support.microsoft.com/en-us/windows/windows-arm-base...
Read Hennessy & Patterson and get back to us.
That can be rendered inoperable any time Apple decides to force you to upgrade. Horrible advice.
Also, ARM/RISC-V is still new. Lots of stuff has poor compatibility, and no, compiling everything from source isn't a solution.
It's nieve to suggest that compiling everything from source is the only way. Windows and macOS work on ARM, as well as many Linux distros (e.g. Ubuntu, Arch/Manjaro, Fedora, Linux Mint, and the list goes on).