The only "real" mods I know of then are the Battlestar Gallactica and P&N Homefront mods.
Not sure on the BSG link, but the P&N one can be found
http://imagemodserver.mine.nu/starfury there. Its a physics mod, not a mission mod though.
Other than that they is a whole slew of smaller ones around, mostly modifing small things.