Trust me friend, when you start playing mods you'll never play vanilla again.
If you want mods that still have the vanilla main campaign just expand on the gameplay, you've got lots of choices. Stainless Steel, Deus Lo Vult, Darth Mod etc. They're all very good and your best bet would just be too go to the m2tw (I'm guessing thats what your talking about) hosted modifications forum and checking them all out yourself.
If you want to get more specialized, theres always Broken Crescent. Same timeframe as vanilla, but it's set far into the middle east. It be what I'm playing now.