Core2 Quad Q8200 2.33 GHz vs Core2 Duo E6700 2.66 GHz
I currently have the E6700...would this be a significant upgrade for games?
More aboutcore2 quad q8200 core2 e6700
simple answer: NOPE.
Not at all. It would be a downgrade. I can't think of a game that would benefit from this kind of "upgrade" you are asking about, especially if ypu are overclocking youe E6700. But an overclock Q8200 will be better than a stock E6700.