Don't go for any DDR2-1000+ rated RAM. They are priced way too expensive, usually $400+.
Most DDR2-800 RAM rated at 4-4-4-12 are overclocking very well (like the ones from Corsair, Patriot and G.Skill....lots of them are going close to DDR2-1100 with 5-5-5 timings...sometimes DDR2-1000 with 4-4-4-12 and more voltage). These are all around $225-275.
DDR2-800 RAM rated at 5-5-5-15 will save you around $50 (on average) from the above, but they usually have very little headroom.
There were a few articles on Firingsquad.com and others a month ago, detailing the advantages of bandwidth/timings with Core 2 Duos. Most of it was almost negligible. Since you already have a high-multiplier chip, you won't need insane FSBs to reach your max overclock like the E6300/E6400 guys do.
EVEN if you can hit that fabled 4GHz with your E6700, you can do it with plain vanilla DDR2-800 running 1:1 (or DDR2-1000 with the 4:5 DDR2-667 divider). And going from 800MHz @ 5-5-5-15 to 1000MHz @ 4-4-4-12 might give you 0-5% increases depending on the application. It's all relative....what price/performance means to you....