No, but it would give you considerably more than what you have stock. As a matter of fact, if you have decent RAM you might get it to 3.4ish. Once you have it Overclocked, then judge as to whether or not it is letting you down "a bit" in games. There is really nothing wrong with an Q8200 per se and for the majority of computer owners it is more than enough horse power. Once you step into the arena of the Q9XXX your in a different ballpark. In order for the Q9XXX to be much more effective than what you have, you have to overclock it as well. Once you go down that road, you can't stop. It will require a not just a "decent" motherboard, but a good one. It will also require better than average RAM and top end air cooling. That all might lead to a better Power supply, and then the cycle continues to your GPU. A simple upgrade is never just a simple upgrade. Once you have spent all that money on those components, you will ask yourself, why didn't I just get an i7?
So as you can see, the answer is not a simple one. To answer whether or not it would be giving you the same performance. An overclocked Q8200 will give you equal performance of a Stock Running Q9550.