Recommend me some Skyrim mods

I'm looking for some decent mods that add content to the game without feeling artificial or shoehorned in. Some mods to make the game look nicer would also be great. I know I'm incredibly late to the party on this one by the way, but I was holding out for the Legendary edition.

This is a great place to start.