I’d look at Lenovos P620’s. It’s a threadripper pro cpu and you can stick up to 512gb ram in it. They’ve been around for a few years now, I got mine in 2021, so you may be able to find them cheap. Lenovo also has slightly smaller workstations that would manage all that but I think they’re pretty new so you’d be buying directly from them. Let me know if you have any questions about the p620. I have a 12 core with 128gb or ram and it’s a great home server and would run that workload just fine. Midtower case that’s really quiet.

That thing will be pretty loud especially if not cooled during your summers. Just be mindful of that. I might just upgrade the ram to keep the silence of the towers.