Any SSD you buy nowadays will be utterly obsolete and small way before you would start seeing nand failures. I recommend you give that RAM to Windows instead of spending it on a ram drive (or give it to Shadowplay, and let it save more seconds into memory).
In the early days of DOS and Windows times, ram drives had a good use for many different scenarios, but nowadays, modern operating systems and applications can use and do appreciate the more ram as cache or whatever else they might need the ram for. Ram drives can also create unwanted page faults and cache misses, so they can make things even worse in some cases.
For me the most important "scenario" is still simply utilizing a boost in data transfers. Even if you have a PCIe SSD with read/write speeds around 1GB/s, RAM drive will be 10x faster.
As for SSD failures:
What you said is obviously true for typical users (multimedia, games, office tasks).
This is NOT true in general.
Lets assume an average consumer SSD available today can write ~1PB and will be used for 3 years. That gives around 1TB a day.
Obviously, that is A LOT. There exist people that won't write as much data in their life (intentionally, so putting aside cache).
Some people can easily write 1TB a day because of a hobby, a home office activity etc. There is a vast number of ways you can use a PC - some stressing the hardware a lot more than gaming (even with shadowplay...).
Even in large companies, enterprise-grade SSDs (with much better lifetime) are used only in servers. You won't find them in high-end business laptops by default.