I was reading a BF2 tweak article and it mentioned two mod groups that have released products that "come highly recommended and transform BF2 into almost a completely new game from the ground up." After looking around at the screenshots on these sites, I have to say, they look pretty awesome. These packages are larger than what EA gives and look to be of similar or higher quality. Check them out!
Point of Existence 2
http://www.pointofexistence.com/Project Reality
http://www.realitymod.com/There are also more map packs and tweak info available here:
http://www.tweakguides.com/BF2_4.htmlS!
TX-EcoDragon
Black 1
TX-Squadron XO