you have to look it up per game. a sizeable portion of games today is multi threaded, but they work best on two threads.
Even though crysis supports 4 core multi threading (only other game i know of is supreme command), it still plays faster on an 3ghz intel dual core then a 2.4ghz quad. And the penryn adds another 10% compared to the older C2D.
A quad core extreme at 3ghz would certainly beat a 3ghz dual core for crysis, but at comparable prices and lower speeds, you are still better off with a dual core. Especially if you OC (since the duals OC higher)
with a Q6600 without OCing you will definitely have to worry about CPU limitations IMAO. In the long run it might work out better as future games might suddenly become better at multi threading, but it is hard to predict. Plus, it makes more sense to buy what is faster today, and in the future buy "future tech" for a fraction of what it costs today... I have a policy never to buy tech that does not have tangible benefits TODAY. Because 1/10 times it will be obsolete or a fraction of the price by the time its benefits show.
I just ran mass effect on my E8400 oced @ 3.6ghz + 4850, on 1920x1200 particles high (max), textures high (there is also very high which is unplayable) and no blur or grain effect.... I have vysnc on but i am not even close to 60fps, I can feel some lag...
I was getting 95-100% CPU usage steady. No idea how much GPU usage there was, due to rivatuner not wanting to work properly with the 4850 (I guess i need to do the cfg mod like with the 8800GTS 512... or wait for the next version).
So I am clearly CPU bound, and it clearly scales very well on 2 cores if it manages to actually show me 100% usage. And I am not managing even 60FPS, even on such a system and setting combination.
Which surprises the heck out of me, I wouldn't have dreamed if it if you didn't mention mass effect yourself.
EDIT: PS, CPU has made PATHETIC advances in the past 2 years or so... compared to GPUs and other hardware... Nehalem shows promise, but until it hits we are stuck with relatively very "dated" CPUs... even with newer ones like penryn...