Both your CPU and your Videocard are bottlenecks. However, given Doom 3 is highly graphics intensive, GPU is the greater bottleneck. For Doom 3 in particular, 6600GT would give you a nice boost. However, I do no see a point of just getting a new videocard for 1 game. You could either a) overclock the current cpu to 3ghz b) get a new videocard, c) or both a & b.
But honestly, the only way to really understand is to look at benchmarks (or do tests yourself). So here:
If you have a 2.4GHz Pentium 4, is it worth it to upgrade to a 3.4GHz P4 in order to get greater performance in Doom 3?
As you can see from the graphs below, P4 3.2ghz with 9800Pro gives exact same framerate as P4 2.4ghz with 6800Ultra.
BUT, the latter system is running at 1280x1024 High Quality vs. 800x600 Medium Quality with 9800Pro.
Looking back at 1280x1024 High Quality graph, we see the performance improvement from 2.4ghz to 3.2ghz is only 13%.
I should mention this is a 2.4C with 800FSB CPU tested. However, as someone mentioned above 2.4s tend to overclock fairly well. Even if you get 2.8ghz out of this machine, your best bet for gaming is always the videocard. For most bang for the buck, get something like x800xl or 6800GT ($300 at
www.outpost.com by PNY), or save some $$ and get Venice S939 cpus and maybe new generation of cards? Depends how much you want to spend and how long you want to wait. (note1: try to sell the 9800Pro to help you finance the new videocard purchase; note2: you could keep the PC2700 ram for an A64 system since the performance drop isnt significant. Then again PC3200 1 gig is only $100 nowdays).
Also,
Half-Life 2 Performance Preview: The Graphics Hardware Squeezer
You can see that ATI cards perform much better for HL2. Therefore, 6800Ultra would benefit here but not as much as the X800XL. Unfortunately, if you do upgrade the videocard, you'll have to decide which games are more important for you.