I played Tamriel Rebuilt and another mod that adds the Twin Lamps as a joinable faction recently, and it's not even funny how much better they both were than the vanilla content. Whoever it was at Bethesda that wrote Morrowind's quests genuinely deserves a kick in the nuts, because they're so inane and boring, and modders have proven that it really wouldn't have taken much effort at all to come up with far better stuff.
I usually bounce off Morrowind at some point because how terrible the combat is. I think I need to play non-melee types and maybe it'll bug me less for Morrowind in particular. I had a good time with the usual wandering around and raiding tombs though.
Just power through to like level 8 - 10 (which doesn't take long) and combat becomes mostly irrelevant since you're steamrolling everything. I don't think there's any way to make it actually fun or interesting, the best you can do is just become powerful enough quickly enough that every combat encounter ends before it has a chance to become tedious. Magic lets you piss around with the spellmaker, but the main purpose of the spellmaker is to come up with ludicrously broken shit that again serves the ultimate purpose of letting you end combat ASAP.
You could also try to play as a stealth-mage to avoid combat as much as possible, which I've done, but that's obviously not how the game is intended to be played, and just ends up revealing that the stealth system is the worst one ever made for a videogame. You can essentially bypass the stealth by just casting invisibility on yourself to walk past NPCs who stand there like wooden dummies while you steal their life savings, but that represents its own whole new realm of boredom.