SuperPi computational test shows that even DDR3-1333 cannot outperform DDR2-1066 SDRAM. There is only one thing I can say in favor of the new generation memory: the victorious DDR2-1067 with 4-4-4-12 timings is indeed an overclocker solution and is pretty expensive. DDR3 SDRAM should solve this problem. Memory modules working at 1333MHz frequency (and later at 1600MHz) are pretty standard solutions from JEDEC specification prospective. In other words, they should eventually become cheaper than high-speed DDR2 SDRAM thus offering good performance at a lower price.
There is nothing new on this chart showing PCMark05 results. The numbers do not show any advantages of the new generation memory. DDR3-1333 with 7-7-7-18 timings can only perform as fast as relatively ordinary DDR2-1066 with 5-5-5-15 timings. As for the DDR3-1066, the systems using it perform as fast as those with DDR2-800 SDRAM. And the only actual advantage of DDR3-800 SDRAM seems to be its lower power consumption. Performance is definitely not among its strong points.
Performance in 3DMark06 hardly depends on the memory subsystem settings. Nevertheless, we can see all the above described tendencies projected on the results of this benchmark, too.