What are the best mods to use then? Just installing this on my new PC and wanna start it modded straight away. Thanks guys
As mentioned, SkyRe seems to be a good mod although I've never tried it myself.
I use a lot of texture mods that just generally improve the textures of the game. I'm not a fan of the complete texture overhauls myself, but I have a mod that improve rock textures, another that improves furniture textures, food textures, etc.
There are a few combat mods like ACE, Deadly Combat, and Duke Patrick's. There's a good explanation of the combat mods here:
http://forums.bethsoft.com/topic/1401728-cant-decide-which-combat-mod/There are a few camping mods I've seen, with deploy-able beds and fires for cooking. Going along with cooking, there are some good mods that add new recipes and things to make.
I've seen a wide variety of armor and weapon mods. Most of them have new models that you craft at a forge, which I am not so much of a fan of (I'd rather have the new models integrated in the game or replace vanilla models). Half of the armor/clothing mods are just skimpy anime junk (if I wanted to look at that stuff, I wouldn't be playing Skyrim) but there are some good lore-friendly armor mods out there as well.
Ultimately, just search around and you'll find some good mods that make little changes or add little things. Not all mods have to be huge overhauls, most of mods I download are a bit random. I have a mod for playable instruments, faster walking/slower running, horse riding tweaks, improved animal loot (meats and pelts), etc.