He said he played the game on xbox in the very first post.
I second the notion of unofficial patches. That + Code Patch are a must, and like Pseron, I don't even consider them as "mods", they are pretty much essential fixes for PC versoin of the game. Then depending on what you like or dislike. I'm not gonna go with "know what you wanna "fix"" thing because some things do not necessarily need fixing, but I like an upgrade anyway.
One of my personal suggestions is MGE XE. You can customize it however you want. From having a beautiful water, to set of shaders you can combine (or don't have any at all), to view distance you can play with and have it at vanilla, or set so you can see the entire island from just about any spot of Vvanderfell.
Another personal suggestion is Animation compilation, to replace that old swag.
Then there's a whole bunch of graphical choices, from bodies you have Better Bodies and Robert's bodies, tons of head replacers, of which some of the most known are Better Heads, Westly's and Mackom's. There's a whole lot of texture replacers, and for those you can google up names like AnOldFriend, Apel, Connary, and so on, although there are newer guys around who did great jobs on their versions as well (I just haven't been modding my latest installation yet so I didn't memorize these new members yet). For creatures you also have Connary and Hedgehog who covered retextures of most of them, as well as Tyddy who retextured a couple of creatures, and then you have PeterBitt who lately took over the baton of authority in creature replacers by making creatures from scratch one by one (although he has only 2 or 3 releases so far, I think, so it may not help if you really dig uniformity in the graphical style, although these models are very true to original concepts).
There's also Melchior Dahrk (ericthered1090 on Nexus) who made two mods I never play without- Dunmer Lantern replacer, and Lyithdonea, a huge landmass mod where you get to explore something different from Vvanderfell, but with the same amount of pro-level detail as in the original game.
I could go on forever, but the best idea is to go to Morrowind Nexus and Morrowind Modding History and dig through mods there, there's just too much to list here, and we don't know specifically what are you looking for, nor what are your tastes.