skylinegtr191 :
TF2, L4d, Crysis WARHEAD, FarCry 2, COD4 and COD5, GTA4..
I play them all at 1680x1050 and usually try for high to very high settings. For example, COD4 with maxed settings gives me 50-60 fps and sometimes dips to 40 causing a big of jerking.
I see. Well, I think this is the situation you are looking at.
TF2:
With a GTX 260: Would see very little changes. TF2 isn't graphically intensive at all.
With CPU overclocking: Yes! TF2 is completely single-threaded. I run a C2D at 3.4 ghz, my first core is floored at 99% usage while my second core never goes above 5% usage.
L4D:
With a GTX 260: You'd see some solid improvements. While it's easily playable with a 9800gt, a gtx 260 will allow you to max every setting, turn on some AA + AF and still average over 60 FPS.
With CPU overclocking: Some improvements, but probably not a lot. Valve did a good job of making L4D take advantage of multiple cores, so just having 4 cores usually is good enough.
Crysis Warhead:
With a GTX 260: Would be leaps and bounds above your 9800 GT. Crysis [Warhead] loves powerful GPUs. Especially powerful nvidia GPUs.
With CPU overclocking: A little bit better. For the most part, it's the GPU that holds back the CPU, but it still helps a bit.
Far Cry 2:
With a GTX 260: While not as demanding as Crysis, Far Cry 2 still offers lots of eye candy. A gtx 260 would help you unlock some of it.
With CPU overclocking: Some benefits. FC2 likes multi-core CPUs, but it likes clock speed as well. According to
PC games hardware any quad core will do very well, but you can still eek out some extra frames with a good overclock.
CoD4
With a GTX 260: You already run CoD4 pretty good. A gtx 260 would help to eliminate those dips in framerate, but not do a whole lot else.
With CPU overclocking: I dunno. I've never played any of the CoD series. According to
an article from Tom's, it seems as though it uses multiple cores well and doesn't need super high clocks, but I can't say for certain one way or another.
CoD5:
See above.
GTA IV:
With a GTX 260: Maybe a bit of gain. Not a whole lot though, as GTA IV is kinda weird for PCs.
With CPU overclocking: Probably. The game is more dependent on CPU than GPU, so having some extra Mhz on your side will help.
So there's my guessimation as to how overclocking your CPU and/or buying a GTX 260 would work for you. As you can see, there really is no simple answer as to whether a GTX 260 is bottlenecked by a Q6600. Just like jaydee said, your mileage may vary by game. You'll have to look at how important each game is to you and what you're willing to do to increase its performance.