I have 1,000+ hours logged in SP and 1200+ logged in just cRPG. I like both MP and SP of M&B a lot, and I'd rather they focus on both than just on the SP campaign but it'll be cool to see how much they can do with it. What they've shared so far has been fueling my erection for the last few months. Really hoping Viking Conquest isn't an indicator of what a new M&B game is going to be like(but it was made by a different group than TaleWorlds so, hope is still in the air).
Can you make a list?
Blood and Steel: Sort of high fantasy, you can start with insane stats if you play barbarian(63str and 63ag) and just run around the battlefield at lightspeed with a two hand massacring everything. Pretty fun, its kind of like M&B on crack. Definitely recommend playing on Mommy difficulty if you want any challenge
A New Dawn: The coolest feature this one has is that throughout the course of the game theres a chance of minor factions popping up, sieging other factions castles and forming new factions. Don't really remember other features
A Clash of Kings: Probably one of the most famous ones, its a Game of Thrones/ASOIAF mod. Its pretty fun, theres a bunch of new features.
Perisno: A complete overhaul. Too many features to list. Definitely worth a check out
Nova Aetas: A mod set I think like 500 years after the first game. The factions have been redone, the map has some new cities and some of the old ones are gone. You can found colonys and stuff, theres a new faction based on Native Americans, they revamped the economy, a complete new diplomacy/kingdom management thing that is pretty sweet, and they added guilds and stuff you can join.
Sword of Damocles: Warlords: I dont know if this one has been updated in a while, but it is a pretty cool one. Adds 6 new factions. Expands the native map by a ton. Loads of new features. Port of Sword of Damocles from the orig M&B if you played that.
Floris Mod Pack: Basically takes a bunch of different parts of mods and mashes them all together. Its pretty fun, its a lot harder than basic native IMO.
Light and Darkness: Easily the best SP story mode mod in all of M&B. It blows Viking Conquest out of the water IMO. Only chapter 1 is out right now but they are still working on Chapter 2. It is originally a chinese mod but theres an English translation. Its not great, but its readable and the broken english actually adds some charm to the game. One of the features is your companions shout stuff out when they do things on the battle field and I remember cracking up when Marnid shouted "DON'T BLOCK WITH HEAD! FOOL!" after getting a kill.
Native Expansion: This mod aims to expand native without making it too different. I never really liked it too much but if you enjoyed native(which I don't really) then you'd like it a lot.
Link above is to a website that has a bunch of links with short descriptions to mods on it. Only the people who added them to the database are on there. Other great sites to check are the ModDB, the taleworlds forums, and the Nexus.