Heyo Fancyman5
I'm glad to hear that you're trying to get into pc gaming
As of the Q6600. It's an alright CPU, but it's getting pretty old. Personally I've made a "gaming rig" with the Q6600 and a HD 6970. They pair up pretty nicely, and can play some popular games, such as Dota2, TF2 and CS:GO with acceptable fps.
I'd advise you to go for a newer CPU, but the old Q6600 can still game.
And if you're willing to overclock it a bit, it's somewhat alright to use. (Mine is only OC'ed to 3.0 GHz, since my mobo isn't anything near capable of overclocking)