I'm using a PCIe expansion card to get double NVMe drives for the cache disk, and then three (up to five) 3.5" spinning 8TB drives for long term.
I tried really hard to get it on 32GB but sadly the motherboard only has two slots and only supports 8GB DDR3 modules. I literally ordered some of the rare late-generation 16GB ones and it refused to boot, with no firmware updates available from the vendor (Advantech, board is an AIMB-274).
Buy a refurbished Xeon workstation with DDR4 RAM. If you're in the US or China they're basically free and if you're in the EU, they aren't too pricey (like you can definitely find ones for less than 200 EUR). Slap your double NVMe expansion card, your two NVMEs and your 3 3.5" spinning rust in it. If the workstation doesn't come with a Xeon with lots of cores, just buy one on eBay for $25.