The reason I say that is because if you upgrade the gpu then you have to upgrade the psu to have enough power , you can't upgrade the ram because you have a 32bit OS and you would have to upgrade the OS , you can't upgrade the cpu without upgrading the motherboard. So you see where I said the whole thing has to go because your locked in with those components and one affects the other.
Yes.. I knew all of that. Maybe should have mentioned it in the OP.
There are faster LGA 775 processors (E6600) out there, but I don't know if it's worth it.
Would faster RAM make any appreciable difference?
Is the power requirement of newer graphics cards so much higher that the 6-pin powering my 8800GT wouldn't cut it?
EDIT: Updated the OP to more accurately reflect my situation.
Yes, stop squeezing the old girl. Your CPU is bottlenecking your 8800 right now. You could upgrade the CPU, but the improvement might not be that great, and better chips for that board are going to be hard to find because they're obsolete. I just now failed to find a Quad Q9650. To bump it to an E6600 surely would make no difference. Faster memory wouldn't make any difference, either. You would likely need a bigger PSU for a modern card. Sorry, but it's time to punt. (Does that figure of speech work in rugby, I wonder.)