Not much of a difference, it takes a lot of speed, or really tight timings to make a noticeable difference in ram. That being said, comparing 1000mhz ddr2 against 1600-2000mhz ddr3, eventually with enough speed, it still noticeably faster, even with worse timings.
Sorry if that's not the correct answer, I wasn't really sure what you were asking.
Going from 800MHz DDR2 to 1066MHz DDR2 with a Core 2 system will give you very little performance improvement, if any at all. The main benefit is the ability to run higher FSB speeds without overclocking the memory, since with Intel chipsets the maximum FSB you can run without overclocking DDR2-800 is 400MHz, and that's pretty low for most 45nm CPUs. DDR2-1066 will allow you to go up to an FSB speed of 533MHz without overclocking the RAM.