Would anyone here, ever get CPU's+MB/RAM/PS etc like this (or the Epyc's) for Homelab/SOHO use?
Very expensive, are they not!? But perhaps it is justifiable, in certain niche scenarios?!
If you use your PC for income and what you do is either largely CPU-bound, eats up lots of PCIe slots (i.e. for multiple GPUs), or demands lots of memory, or Intel's AMX, then it might be justifiable. Don't forget about power and cooling requirements, both of which are elevated for this class of CPU.
In 2012, I built a workstation with an E5 Xeon (LGA2011 socket, quad-channel memory, I think something like 48 PCIe 3.0 lanes, etc.). A decade later, I could not justify the premium price of an equivalent motherboard + CPU, especially now that mainstream has become so much more powerful and capable. Even on the I/O front, mainstream CPUs and chipsets really are a lot better than in the bad old days of Haswell and Skylake.
Even if you want ECC memory, there are both Ryzen and Intel options that allow you to use it with their desktop CPUs. If you want that, start with a motherboard that supports ECC Unbuffered memory and then look at the CPU requirements for using it.