Yes, most certainly, test results do show that gaming is affected by faster / lower CAS RAM. The question has always been whether the increase in cost is worth the increase performance. This is oft skewed by an improper basis as the analysis should not be whether say is a 5% performance increase in performance worth a 30% increase in RAM costs .... it's whether a 5% performance increase in performance worth a 3% increase in Total System Cost. Every situation has to be examined individually and the following test at anandtech was designed to present one set of conditions where RAM speed has a great impact on gaming performance.
http://www.anandtech.com/show/6372/memory-performance-16gb-ddr31333-to-ddr32400-on-ivy-bridge-igp-with-gskill/14
Assuming a $2,000 build ....
Metro 2033
DDR3-1600 is 3% faster than DDR3-1333 for a 0.2% increase in system cost
DDR3-1866 is 7% faster than DDR3-1333 for a 1.0% increase in system cost
DDR3-2133 is 9% faster than DDR3-1333 for a 2.8% increase in system cost
DDR3-2400 is 9.5% faster than DDR3-1333 for a 3.5% increase in system cost
Dirt3
DDR3-1600 is 9.5% faster than DDR3-1333 for a 0.2% increase in system cost
DDR3-1866 is 13.5% faster than DDR3-1333 for a 1.0% increase in system cost
DDR3-2133 is 15% faster than DDR3-1333 for a 2.8% increase in system cost
DDR3-2400 is 14.5% faster than DDR3-1333 for a 3.5% increase in system cost
In previous testing on the motherboard side, we have seen that Dirt3 seems to love every form of speed increase possible – CPU speed, GPU speed, and as we can see here, memory speed. Almost every upgrade to the system will give a better frame rate. Moving from 1333 to 1600 gives us almost a 10% FPS increase, whereas 1333 to 1866 gives just under 15%. We peak at 15% with the 2133 kit, but this reinforces the idea that choosing a 1600 C9 kit over a 1333 C9 kit is a no brainer for the price difference. Choosing that 1866 C9 kit looks like a good idea, but the 2133 C9 kit is reaching the law of diminishing returns.
Batman AA3
DDR3-1600 is 8% faster than DDR3-1333 for a 0.2% increase in system cost
DDR3-1866 is 15% faster than DDR3-1333 for a 1.0% increase in system cost
DDR3-2133 is 21% faster than DDR3-1333 for a 2.8% increase in system cost
DDR3-2400 is 22% faster than DDR3-1333 for a 3.5% increase in system cost
Bit-Tech's test are probably more applicable to what most here would experience, though we are hampered by a 489 GFX card
http://www.bit-tech.net/hardware/memory/2011/01/11/the-best-memory-for-sandy-bridge/6
In Civ 5 on one hand one might say that a 2 fps increase is not noticeable, however that's a 9.5% increase in the min fps ..... for a 2.8% increase in system cost. 9.5% is oft the difference in cost between one GFX card and the next GFX card in a higher cost bracket.
Also note that 2 x 8GB will usually do better than 4 x 4GB as the memory controller has to work harder handling the extra 2 modules.