I think they are mostly used as external storage, sometimes backed by spindles as a very fast SAN.

If you need huge amounts of local RAM then I think you're in the realm of the IBM zSeries and other mainframe devices. Nice stuff indeed, when you have the spare change...