just this last week, new build, I have run 3DMark05 with my E4300 at 9 x 333 using both 667 and 833 memory. Both running 4-4-4-12. with my memory multiplier at 2 for 1:1 DDR667 I scored 6615 marks. With the memory multiplier set at 2.5 for DDR833 I got 6650marks. So I saw almost a 1% increase!!! WOOHOO!!! Glad I bough the cheap Patriot Extreme ram.
Basically since the memory is double data rate, when its running at DDR667 its effectively double clocking for 1333Mhz. Which is equal to the CPU when the FSB is at 333. So that any memory running faster, ie DDR800 is going to have to wait for the CPU since DDR800 is effectively running at 1600MHz.
I saw about a 1% increase going from 667 to 833 keeping the same timings. Now if I went to DDR900 and dropped from 4-4-4-12 to 5-5-5-15 I would probably start to see a loss due to the slower timings.