Morrowind couldn't be any more boring. I tried it out, and got bored so quickly.
I LOVE Rpgs, but that's one game/series I can't stand.
I think whether or not you like
Morrowind and the rest of the
Elder Scrolls series depends entirely on which end of the spectrum you prefer your RPGs to fall in.
Some prefer their RPGs to be intricately detailed sandboxes --- meticulously crafted virtual realities in which you get to act out an alternate life --- that favor open-ended possibilities:
Ultima Online for example, let you get away with making a living baking bread.
Elder Scrolls games are infamous for the number of alternate non-adventuring careers you can gain.
Darklands was more intricate representation of medieval Germany than a party quest.
Games that fall on the extreme end of this spectrum de-emphasize storytelling or scripted characters --- if not being generally plotless altogether --- by leaving the experience entirely up to the player, instead of chaining him to a narrative or binding his character growth to monster kills. The game developers doesn't pretend the computer can GM better than a human, and thus creates the world rather than a narrative experience.
Other people prefer their RPGs to be a meticulously crafted plot makes them the hero of a story. Unfortunately, to tell a decent story you have to create a relatively linear experience --- with freedom being limited to branching paths and variable-dependent endings --- and that severely curtails the freedom.
It just makes no dramatic sense for The Chosen One to spend several years of his life becoming the most wealthy cow-herder in all of Tolkienishlandia, then slaughter everyone in the town of Quaintsville because he decided to be homicidal, and then save the world from an army of supermutants.
The best of RPGs, I think fall somewhere in between.
In any case, the point I'm trying to make here is that
Morrowind isn't a bad RPG, it's just built very differently from the RPG you want.
In the same fashion,
Knights of the Old Republic isn't a bad RPG, but it's hardly as open-ended and 'role-playing' as other RPG fans want it to be.