I really cannot wait for the 1.0 version of the bf2 mod project reality. Its difficult to explain in a short space of time, why you should care about a mod of such an ancient game. So I'm not even going to try right now, maybe when the big update comes out.
For now lets just say gameplay > graphics. And it has some emergent gameplay like nothing else. I recommend watching some gameplay videos if curious. I made a quick, not so serious one myself recently;
Check out http://www.realitymod.com/