With gaming, not one bit. I have no idea what BF2 takes. If it follows along with 90% of software, the X2 will surely be a better option. The Pentium D's just aren't fast enough to be competitive (and the 820 and 830 are the only decent ones for the cost). A 3.4 or 3.6GHz might be able to compete, but overall, the X2s have a lot of power for the money. He's mainly been wrong on RAM (technically, anything over 200MHz is over spec, but you can definitely get up there; timings are in clock cycles, not ns; tighter timings are pretty much always better).
If it's going to be on a LAN, rather than a 'net server in a little hole at the ISP, then by all means, see about OCing, as you can be there to monitor it

. Get a nice DFI or Epox board for the money (~$150 should be plenty for that). I don't think that config can really be boosted much more, unless you want to up the CPU and bring the Raptor down to 36GB--but that might be too small after a time, and doesn't net that much faster CPU (though it could allow for some better RAM, as well, it's probably not worth the penny-pinching).
If you plan to OC, maybe add in a nice cooler, like a Zalman 7700 (if it fits, it's a good compromise between cost and performance), Ninja (best, but not as cheap), XP-90 (fits anything, nicely priced, even w/ a fan added into the cost), SI-120 (should fit, but somewhat expensive), etc.. If you have to bump the voltage up on the CPU, a beefy cooler will help a lot.