i'm not sure how exactly steam workshop works, so i'd prefer using Nexus Mod Manager and these sites
http://oblivion.nexusmods.com/ http://morrowind.nexusmods.com/you have to register on them in order to download larger mods. i dont remember exactly what mods i have and what they do but here's screen shots of my oblivion and morrowind
Oblivion was straight copy paste of my mates mods, so cant say much about them. on morrowind i dl'd only couple of mods, because it doesnt need much mods. one mod i would add in morrowind would be Better Bodies, but couldnt find working vers