Desert Combat rocks... and a new mod just came out... its only in its first release its called Galactic Conquest, its a Star Wars mod for BF1942
Its kinda rough because its a first release but it has ALOT of potential.
http://www.swbattlefield.jolt.co.uk/index.php
You can also try Eve of Destruction which is a Korean War mod for BF... i dunno its site though.