I settled for 768GB when I tried a few months ago and it wasn’t cheap. They did have like one HANA class system that was multi-TB at even crazier prices but I was kind of disappointed when I went to do something like you suggest. It was also impossible to get a lot of RAM without overpaying for a lot of cores I didn’t need and couldn’t use.
I don’t disagree with your point about the optimization benefits of just caching data but actually getting a cache optimized system is seemingly another thing entirely. My perception is that it’s been hard to get >768 GB systems for a bunch of years now. But I don’t follow this space closely,
But for many companies building such systems (custom line-of-business software is probably still the largest part of software development happening in the world) it's highly probable that if you can "bail your poor decisions out" by just buying RAM, that's is far more efficient than rebuilding parts of software - a saved man-month of engineering can buy a LOT of RAM; a terabyte of it is probably in the range where it's not even particularly worth trying to carefully evaluate the options as a well-staffed meeting or two discussing the possibilities can be more expensive than buying a few RAM sticks more.
I complained about how slow my 1 Meg 386 was and wanted a 486, he said he had 16 megs of ram (kind of insane at the time) and always said "the system will wait on you"
That was somewhat true until you went to load a new file or program that wasn't cached yet, or when a heavy re-draw occurred and a 4mb 486 would dust it. You just didn't page anymore, which happened a lot back then.