You may see a few more FPS on games but on a day to day usage point of view, like jokester says, you will see very little difference at all.
I ran some 533mhz memory oc'd to 660mhz with 4-4-4-10 1T timings and them compared them to Corsair XMS2 at 800mhz 4-4-4-12 2T and the Corsair was actually beaten in most memory benchmarks. I only saw a difference when I upped the voltage of the Corsair and had them at 900mhz 4-4-4-12 2T.