There are a few good mods on the Skyrim Guild website. They are mainly focused on combat and animation.
Skyrim Mods
This is a place to talk all about Skyrim Mods!
Rules:
1 | Keep discussions centered around Skyrim modding.
- If you want general discussion around the game, check out the communities at the bottom of the sidebar!
2 | Keep discussions civil and friendly!
- We strive to keep a safe and friendly community!
3 | Tag NSFW content as such.
- There are tons of NSFW Mods, but some people browse at work or around family and friends, they don't want to see your Khajiit titty mod!
4 | Memes are allowed on Thursdays, just keep them focused on Skyrim Modding!
- Sometimes we just need a break from dealing with our mod lists!
5 | English Only.
- Other languages makes it much more difficult to moderate.
Community Resources:
List of Modding Resources/Modding Guides
Other Communities:
Arthmoor's various village mods (adds and expansions) on AFKMods. They look like they came with game disk. They add stuff that it's hard to imagine wasn't there before. Like a house for Lokir in Rorikstead.
Sforzinda's armor and clothing mashup mods are always my first answer to this question, because they are so good. The Nexus has supporting patches, like bodyslide conversions and compatibility tweaks.
My second answer is always high-poly-head, which is a SFW mod on a very NSFW site. But it's such a good visual upgrade!