"SSD as RAM" is a bad way to think about it. What you need to realize is that the standard for games has been to treat RAM as storage, because the hard drive was too slow to use for loading data on the fly. SSDs mean games can use storage as storage, but they still have to fit the working set in RAM.
And that's really what the hype is about in terms of better game experiences on these new systems — we should be able to have larger working sets because you don't need to waste RAM as storage.
To get specific about what this enables, I think we will see many more indie games with great looking graphics. The combination of high res asset scans, automatic resolution scaling, automatic texture compression, generally less tight performance budgets that don't need teams to do optimization work (next gen consoles), and a financial model around tools to take advantage of all of this (Unreal + Quixel as the leader here) should make this next generation of games pretty awesome.
