really, really beefy dual socket xeon probably, or amd epyc, with 2TB+ RAM

Surprisingly, because most CAD and computer graphics programs are still largely not optimized for multi-threaded processors, the fastest workstations are typically using whatever processor tops the single core compute performance category, not the multicore. They are then paired with as much ram as the chipset supports. Also, when you are talking about pro graphics cards like Radeon Pro and the RTX A (formerly called quadro) lines, it only pays to upgrade to the next gen graphics card once your software vendor has had a year or two to integrate with a new hardware gen's capabilities. The pro gfx card market (at least when it pertains to OpenGL performance) is one area that will actually punish you for being too early an adopter, which is disappointing when cards go for several thousands of dollars new. The whole area of CG software has been stagnating for 5 years while OpenGL driver improvements have fallen out of favor for more bare metal processing approaches that are only now getting to feature parody and developer adoption like vulkan. Hopefully the next few years brings a positive trend in CG price to performance again as these new architectures actually start shipping in CG software products. As someone who works daily in CAD, the performance stagnation over the last 5-10 years has been depressing to say the least.

Feature parody is such a good turn of phrase.

Thanks. This is totally new to me. I guess it's the same pic for professional level designers or game designers who basically work in a CAD like environment? For example the people who design levels and scripts for games such as Skyrim.

Got it. I Google around and surprised to find vendors who basically build workstations from market components. Not sure whether they are mainstream though.