Yeah, you should be fine to play anything that's out there or going to be out there in the near future... One thing to check out, newegg also has a 6600 for $150 right now (after a mail-in rebate) which is equivalent, if not better than that 9800Pro...
No. It will not run BF2 on high settings. My friend has an ATI Radeon 9600XT, and an AMD Athlon 64 3200+, along with a gig of ram and he can barely run it on medium settings.