I used to run a Q6600 @ 3.2Ghz (had an 680i motherboard that sucked for OC'ing). I ran it with an 8800GTS 512MB, then a GTX 260 Core 216, and later dabbled with GTX 260 SLI. Eventually I upgraded to an i5-750 and OC'd to 4Ghz. Though my Q6600 gamed very well, I definitely noticed performance improvements from the Q6600 to the i5. Granted the i5 OC'd better, but the architecture is better anyhow.
You should do fine with a GTX 560 Ti on that Q6600. However, since there are a couple of game titles these days that like fast quad cores, you could lack a little in those cases. Just run as high a monitor resolution as you can and you'll minimize any potential for seeing a bottleneck visually speaking.
The GTX 560 Ti appears to match the GTX 470 performance wise in early reviews. And in my experience, a GTX 260 SLI pair equals a GTX 470 as well. Based on my own personal benchmark results in July 2010.