some more obscure morrowind mods i enjoyed:
the prison ship escape
children of the night (was supposed to be 3 parts, not sure if it was ever finished)
The prison ship escape is a fun story about the Juib guy you meet when you create a new character. You have to rescue him. I remember one part being kinda tricky to initiate the next part of the quest, but the readme probably has a walkthru.
Children of the night was kinda cheesy, but it involved a few cool fights. Some of pics i saw for part 2 and 3 added some beautiful (well, for 2002/2003) textures. Im pretty sure part 2 was released but part 3 was not