Also, I do have two 4 pin molex free, on a 400 watt power supply. Would that change your recommendations at all?
I would probably still stick with the 4670. Unless your power supply is top tier and has at least 25 amps on 12v rail. Then I would recomend a 4830 or 4850 whichever is in your budget. Both draw 110w. By comparison the 4670 draws 70w, a huge difference on a small, budget psu.
From newegg on a 4830: PCI Express based PC is required with one X16 lane graphics slot available on the motherboard 450 Watt or greater power supply with 75 Watt 6-pin PCI Express power connector recommended
Also you said you mostly play BF2. Well a 4670 should blow through that no problem. According to Toms Charts, the 4670 gets 60 fps at 1900x1200 Max Quality with Call of Duty 4, which is about the same performance as BF2.