I'd suggest a Geforce 6600GT would be perfect for you then, as it'd play all those games in great detail/res's.
If you wanted more future proofing though, the Geforce 6800 would of course be your best bet. One of those styles, GT, Ultra, etc.
Theres standard you see, then GT, and then Ultra I believe.