The other DLCs are not as large as either Shivering Isles (an expansion) or Knights of the Night.
The main other mods are "house" mods with no substantial quest. Which one, of course depends on your character(s). Pretty straightforward: Wizards Tower (Frostcrag) for mages; Vile Lair for Vampires and/or evil characters; Fighter's Stronghold (Battlehorn) for warriors; Thieves Den for thieves.
I really like Wizards Tower and Vile Lair. But again no big quest associated with them, so if you're expecting another KotN you may be disappointed.
Spell Tomes just adds books to loot. When you read them you learn the spell.
Horse Armor and Orrey are lousy in my opinion.
If you're looking for another questline, and are on a PC, I recommend mods vs additional DLCs.