can you give me a brief insight into how a cpu/gpu mismatch would affect my FPS in games
Well, basically graphics cards and game engines need a certain level of CPU power to (with graphics cards) get the best out of them and (game engine) handle all the other stuff AI/physics etc to keep it running smoothly.
With your 9700 Pro the CPU can more or less keep up and even if upgraded to a Core 2 Duo it is unlikely you'd see much of a frame rate boost (except in those games which require the CPU to do a lot of work, where it isn't handling it too well).
Generally speaking the graphics card has more influence on the maximum frame rate, just how fast your PC can plough through the game and it will handle all the fancy effects (like water, clouds etc) which would cripple the CPU along with the grunt work of pushing pixels. The CPU on the other hand has more influence on the minimum frame rate and how smooth it'll be (since if it is struggling to handle the game engine it doesn't matter how fast the graphics card is pixel pushing, it'll *still* chug).
If you are getting a graphics card issue but the CPU can cope then you'll find the game chugs when a lot of action is on the screen and particularly in complex areas (like where there is pretties, i.e. special effects, explosions, many characters etc) while a CPU/RAM issue will be a generally uneven frame rate along with periods of unexplained chugginess (where there is no obvious cause like a graphics card has with many characters on the screen) and make the game hard to play most of the time rather than only when there is a lot to render.
The bottleneck comes about when the graphics card can happily render the scene but the CPU struggles to keep up with it, you can usually alleviate the bottleneck by turning on pretties (like AA/AF) and cranking up graphics/detail settings until the graphics card itself begins to chug. The snag is it might still not be very smooth and if the CPU really is much too slow for the game it doesn't matter how powerful the graphics card is, you won't be able to play it.
Usually you will find that games like strategy and RPG (games like Oblivion are more of an FPS-RPG though Oblivion makes heavy use of both the CPU and GPU) are more CPU intensive (you'll see a nice increase, smoother gameplay with a faster CPU) while shooters in particular are graphics intensive (i.e. you'll see a nice improvement with a faster graphics card but not so much with a new CPU).