Yeah, the 9800 Pro is a good card, should be able to handle everything you've listed up there, and any other games you throw can throw at it that are out right now. If you have the extra money, I'd invest in the 9800XT however, it'll be able to last a bit longer than the 9800 Pro.
Intel C2D E6320 / AMD Athlon X2 3800+
Gigabyte 965P DS3 / DFI nF4 Ultra-D
2GB OCZ Gold PC2-6400 / 2GB OCZ Gold PC4000
eVGA 8800GTS 320MB / eVGA 6800GS 256MB
150GB Raptor / 74GB Raptor
2x500GB / 320GB
OCZ GameXStreme 850w / OCZ StealthXStream 600w