More often than not, I find the impact of an SSD vs HDD to be entirely game dependent. My system has 32GB RAM and my GTX 970 has 3.54GB VRAM. Plenty of fast RAM to load assets to.
I play a few MMOs like Rift, Marvel Heroes, and WoW. Not only do those games consistently launch faster from my SSD game directory, but warping to different regions is faster, bringing up large inventory is faster, and little hitches, frame rate dips, and stutter completely disappear no matter how many other players are in the area. When I play these games off the HDD game directory, it is a terrible experience (in comparison). There are so many assets that just simply aren't loaded into memory until they are needed - no matter how much memory you have.
I think games that are designed around the lowest common denominator (2-4GB RAM, slow HDD, weak CPU) are the games that will truly shine using SSDs because the game is built around bottlenecks rather than expecting gamers to build around them with superior hardware. Also, some game engines are built entirely around streaming textures from a console DVD drive or hard drive, where RAM is limited, so when those games are ported to PC, the behavior of the engine consumes all the IO it can get.
Meanwhile, other games like Battlefield only see improved loading times, but not much else. From my own experience, SSDs always end up being better for gaming, the degree to which depends on the game.