Forgotten Hope -
http://forgottenho...iles.com/main.html Its a HUGE download, but I've heard its one of, if not the best mod out there. It changes pretty much every aspect of the game, mostly adding/skinning/tweaking weapons and adding/tweaking the vehicles.
I never found a server that was fast enough to download the whole thing, so I never bothered but I would suggest it. The BF1942 stock weapons fucking suck. The BAR has too little recoil, the Garand is too weak and the K98 is way too in-accurate... hell, all the sniper weapons are too inaccurate.