This is a complex issue, that is highly dependent on exactly what you want to do with that RAM.
In most cases, it is cheaper and better to simply replace the motherboard with a new motherboard that supports the amount of RAM that you require. I have a motherboard here in front of me that can take 16 memory modules. The largest module available is 32-Gig. That's a total of 512 Gigabytes in a single machine. (Never mind that 16 modules of that size would cost about US$14,000, or that the MoBo also has dual 8-core CPU's on it.)
Having the RAM on the MoBo means that it is the highest speed possible. You can use it for both a RAM-Disk as well as normal program and data storage. The best of both worlds.
But in your question you keep comparing it to SATA storage, so I am thinking that you'd want to use this extra RAM as a RAM-disk and not for general CPU RAM. This is a valid use, and years ago people did have PCI cards with lots of RAM on it specifically for this purpose. Those cards looked like another disk drive, and not just more CPU RAM. Often these cards had an external power connector on them so you could give them some sort of backup power in case the main power failed.
These types of cards have largely gone away. They were obsoleted mainly by three things: 1. Motherboards now can have much more RAM on them than in the past. 2. There are more modern solid-state drives using Flash memory and PCIe (some with large RAM caches) that work better. and 3. They were just too expensive for what limited advantages it gave.
There are other reasons why you might want to have a PCIe card with lots of RAM, but all of them are applications where the card is doing something other than just storing data. Like Video cards, or data acquisition cards. These things do not apply here.
Would be great to have like a "L2 RAM" -- something the OS could page stuff into if it needed -- i.e. for your DDR4 system, you could have a PCIe card that took your old DDR3 DIMMs and exposed them as an L2 RAM to the system... – BrainSlugs83 – 2015-09-14T15:43:06.553
http://www.sandisk.com/about-sandisk/press-room/press-releases/2012/sandisk-launches-pci-express-based-products-for-enterprise-applications/ – None – 2013-02-01T17:00:48.883
@rawbrawb, I think that is a SSD, not RAM. – Brian Carlton – 2013-02-01T17:52:03.727
@BrianCarlton mea culpa! – None – 2013-02-01T19:17:04.723
3Note: Almost no PC have PCI-X. It was only found in server market and tops out at around 1 GB/s. Furthermore it's obsolete. It was development based on classical PCI and is not related to PCI Express (often abbreviated PCIe). – AndrejaKo – 2013-02-01T20:31:01.660
There are cards like this: http://www.fusionio.com/products/iodrive2/
– Bill Lynch – 2013-02-02T07:12:41.710Thank you for pointing that out AndrejaKo, I just assumed eXpress since I had seen PCIx before. – agweber – 2013-02-04T16:09:02.970