I mostly go for quality of life and stability ones. There are some decent guides on the Steam forums which I usually go through when I'm modding it. I usually just go for the unofficial patch, the view distance one, and a few more small ones. I'm kind of a purist so I don't like all the graphics update ones but there are some that are just essential. You'll have to get the MWSE (Morrowind Script Extender) in order to get some of them to work. I'll link one of the guides that I usually skim through to pick and choose which ones I want. The one for view distance is called Distant Land and requires the enhanced graphics mod.

It'll be a bit of work, but once your done you'll have a much better time.

https://steamcommunity.com/sharedfiles/filedetails/?id=2208675449