I've never been a fan of trolling forums to try and figure out what mod out of so many that seem shit to try and find what to install to make the game experience tolerable.
I know so many say the PC experience is all about spending the time to tweak the game incl. mods to your liking but sometimes I just want to install the game and play not spend hours just to get it work; I really wanted to like Oblivion but unfortunately that never happened... then again I never went out and tried to find the mods which I now see people are saying made the game alot better... such a shame...
You don't need to troll forums to figure out which mods are good. There are sites dedicated to doing that for you. See
http://www.skyrimnexus.com/. Expect that site to fill up quickly once the game is actually released. It has a list of the top 100 most popular mods. You can sort by ratings, downloads, etc, if you want.