First you need to remember that BF2 only supports these video cards

quote
Radeon X700 (PCIe)
Radeon X600 (PCIe)
GeForce 6600 (PCIe)
GeForce PCX 5900 (PCIe)
GeForce 5800 Series (AGP)
ATI Radeon X800 XT Platinum Edition
ATI Radeon X800 PRO
ATI Radeon 9800 Series
ATI Radeon 9600 Series
ATI Radeon 9550 (RV350LX)
ATI Radeon 9500 / 9700 Series
ATI Radeon 8500 Series
ATI Radeon X300 Series
NVidia GeForce 6800 Ultra
NVidia GeForce 6800 GT
NVidia GeForce 6800
NVidia GeForce FX 5950 Series
NVidia GeForce FX 5900 Series
NVidia GeForce FX 5700 Series

Also, are you looking for a PCIe or AGP card? So far, the card that runs BF2 the best is the X800XL (or thats what I heard). If not then a X700 PRo will also do. EA recommended Nvidia cards but ATIs preform the best. The 6800GT does very nicely in the game actually , it runs very smooth(or i think so) .