I have a Asus P5Q with a Q9650 overclocked to 3.8Ghz. With an EVGA Classified 4GB 770GTX. I consistently play Skyrim with over 110+ Mods, including all of the High Res Texture mods i can find at 1920x1080, i use about 1.7GB - 2.4GB of video card ram during a regular gameplay. I also play Batman Arkham City and Origins sometimes in Nvidia 3D mode with no issues. I have a Acer 120Hz monitor. I can hit 120FPS with vsync on in skyrim *almost all of the time*. And the times it can't it 120fps it is because the vid card can't keep up (showing 99% usage in EVGA - the CPU shows about 60-70%), i run EVGA precision and monitor the video card usage % and PCI-E bus usage. my PCI-E usage is usually at 15-17%.
3.8Ghz on this CPU should be easily attainable with even a semi-decent heatsink/fan.
I admit this isn't the latest-top-of-the-line cpu, but i have YET to find a game i can't play with more than acceptable performance with the High or Ultra in game settings.
Games that i get 120FPS most of the time with:
Star Craft II, Skyrim, Oblivion, FO: New Vegas, Portal 2, Metro LL, X-COM EU, Bioshock Infinite, Path of Exile, Rage, Deus Ex HR, FarCry3, and FC3 Blood Dragon, the List goes on BTW. I will admit i don't play Battlefield or COD.
I wouldn't go out of my way to buy a PC that can accommodate this chip, but if you have it and can overclock it, it isn't a slouch - even in 2013/2014.