Before I can give you a informed answer, I'll need to know your graphic quality expectations and if your Motherboard has a PCI-E, AGP or PCI slot. This is because your system is very out of date but it's still worth investing into a GPU for you to get the most out of your current system. As long as your realistic with what you have, you can easily play those games you mentioned at 1280 by 1024 resolution w/ medium/low quality settings. But with what I know so far, I'll recommend a AMD 5670 or 6770. It will run you only about $75-85 but with your current CPU, that's might be pushing it. And as a side-note, stay AWAY from "Powercolor" GPUs.... you've been warned!! @_@;;
@Zero_ I'll have to disagree with your suggestion b/c a 5770 will get seriously bottle-necked by his CPU - on top of the fact that it costs more and he will "probably" need to get a new PSU to go with it. Also, I wouldn't recommend getting a new CPU either b/c your currently running DDR2 Ram as well, any investment beyond the much needed Graphic Card will have diminishing returns in terms of performance - your better off getting the GPU I mentioned and start saving up for a new PC.
~Coffee