My computer is crap so I can't recommend any mods that improve graphics and all that, but here's a short list of mods that I refuse to play without:
Necessities Of Morrowind (adds hunger, thirst, drunkenness, and sleep deprivation, as well as cooking)
Morrowind Comes Alive (adds many new npcs to all towns in the game, and more changes I don't have time to list)
Vampire Hunger (when you are a vampire, this makes it so you suffer increasing penalties the longer you go without feeding)
Vampire Embrace (allows vampire players to create vampire followers out of nearly any npc in the game)
Galsiah's Character Development (vastly improved attribute/skill/levelling system)
Also, eventually you will want to start over or try a new type of character, and so I also recommend:
Chargen Revamped
Sorry for the lack of links. I don't have the time right now to look them up.