It might at low resolutions like 1280 x 1024. It might at stock. It probably won't if you game at 22" or 24" LCD resolutions. It also won't if you overclock it. CPU limitations exist, but tend to fade away at higher resolutions.
I'm still gaming with a 17" CRT at 1280 x 1024, and I had an Athlon X2 4600+. Once I went to the triple core 8750, I noticed an improvement in framerate across the board with my 3870x2.
You'll be fine with a Q6600.