I would really recommend a 6800 gt but your cpu would be a bottleneck and for the latest games like Farcry,Doom3,Half life 2 you might want to upgrade your processor and motherboard soon or get a new faster pc.
If you dont want to upgrade your pc right now then the 6600 gt i listed will be fine or a radeon X800 or above.
Any more questions just ask me.