My favorite mods (not in any special order):
1. Frostfall: It basically makes Skyrim's weather effects realistic. You can make it matter how much armor you're wearing, what kind of armor, etc. Depending where you are in Skyrim, the weather effects will act accordingly. So if it's raining...