Some really HD weapon retextures like the one Millenia started but didn't finish http://skyrim.nexusmods.com/mods/1754
and the same thing for armors but those are easier to find.
I love Tundra defense and sometimes look for other similar mods but RTS is the only one close to it that really is something.
And better magic mods, which currently is still the mod named "better magic" because it keeps the vanilla spells but balances them in a way that they are more similar to melee weapons and bows when it comes to doing more damage by picking perks. It makes them just as strong as melee weapons instead of too weak like the vanilla magic or way to strong like most mods do.
My mods come from the great Nexus ofcourse, workshop is for pussies.
Mods that add or fill out the content of the game - by which I mean those which add quests or factions (or fill out the ones already there). Also those which add life and immersion to existing locations, or add new locations to explore.
Personally, I've little interest in purely graphical mods - its about adding content from my perspective
I get my mods from Nexus exclusively. I don't like that Steam automatically updates mods for you as that can lead to some serious problems if the mod needs to be cleansaved before an update. I prefer the NMM method that simply shows you when a new version has been released.
Anyway, I'm almost always looking for immersion and gameplay mods. I do have some armor mods installed and I tend to go for a lore-friendly and detailed look in that department. Also mods that increase variety while maintaining realism. Or mods that balance something that I feel is unbalanced.
That said, I love perusing player homes, though I rarely download them. I'm never satisfied with a player home unless I've made it myself.
I agree re Steam Workshop. I only get player homes from there to do a mod review for my showcase videos. Keep the ones I like best but don`t have them auto updating.
Player homes please feel free to check out my youtube channel I reviewed some of the lastest ones and more on the way. I found a zoo today :)
If you have or find any mods you like me to include in a video showcase review please let me know.