> Though the other day I learned there are many technologies for "RAM"

I'm an advocate of sticking a $5 16Gb Optane stick from eBay on a $10 M.2 to PCIe 1x adapter from eBay. Set it up as swap in Windows or Linux. Or pay $200 for a 16GB stick of DDR5.