Is there any way you can change your work flow to not use such resource heavy software? I’m not sure what else there is that can give you similar results with less need for memory & compute power, but that would probably be the cheapest solution. Is this something you are creating as a hobby side project, or are you making money on it? If it’s a mod for a popular game maybe you can monitize it with a Patreon?
I would caution against server hardware being used as a workstation/ desktop as there are several issues that may or may not cause you headaches. First is the board and system design around extreme airflow fans with plastic shrouds to direct airflow over tiny VRM heatsinks, RAM, CPU, network chips and other components. Next is it outright missing a ton of “basic” IO like headphone & microphone jack or any audio chips of any kind, extremely limited motherboard connectors for front panel ports, extremely sparse back panel port selection and usually no option for an IO shield that fits a readily available desktop case. No reinforced PCIe slots so modern large GPUs can damage the motherboard if the GPU isn’t physically supported well in a normal desktop case.
Then performance issues with Epyc, it doesn’t have “good” per core or multi core performance in comparison to moderately high end older desktop setups like AM4’s 5950x, or a 3rd+ generation Threadripper CPU. If your software will take advantage of as many cores as possible and hammer them, I am pretty confident it would do significantly worse on one Epyc rig rather than a decent spec TR or consumer setup.
If you absolutely need a ton of RAM, a Threadripper TRX40 motherboards & something like a 32core 3970x will give you a theoretical max of 256GB 4 channel DDR4 (desktop or ECC RAM). AM4 and a 5950x a max of 2 channel 128GB desktop DDR4 RAM. But a WRX80 motherboard and a 32 core 3975WX would get you 8 channels of DDR4 with a max of 1TB of ram (it will be UDIMM, RDIMM, LRDIMM, not desktop memory).
Availability of an older motherboard plus an “unlocked” CPU will be kinda an issue getting what you want, but the price of DDR4 desktop memory is kinda high, double so for ECC or some variant of Server DDR4 memory. I got a used 256GB 8x32GB kit of 2666 ECC memory for $352 in ‘24 and the same used kit from the same seller is about $3,000 now… there are other kits a lot cheaper, but especially with servers & high end systems you almost always have to ensure the RAM is actually on the RAM QVL for the motherboard or it won’t work maybe at all, or at best probably be unstable. No QVL = No Buy for RAM.
Do you have the budget for 128GB-1TB $1,500-8,000+ in ECC memory? Plus the $1,500-3,000+ in the used motherboard + CPU, plus $400-900 for a good high wattage PSU, $200-ish for a UPS & ESPECIALLY a good 4.0 x4 NVME drive? GPUS are kinda nuts right now as well and your current drive would likely hold back system performance.
I can try to test your file on my Threadripper rig later today, if I can get & figure out the software. Are there any benchmarks relevant to that software that will give a relative measure of performance?