I haven't played any other TES games (besides a few hours of Daggerfall), so I can't compare Morrowind to Oblivion or Skyrim. But I can tell you that Morrowind is a strange beast. Just about every core mechanic is either bland or broken, and the quests range from acceptably average to "why bother?" But its virtues lie in its amazing atmosphere and world, deep lore, and incredibly open-ended play. It's less an RPG and more a huge world to play around in and explore. A true sandbox.
There's a lot to see and do. A LOT to see and do. There are hundreds upon hundreds of spells, potions, and scrolls for magic. Alternatively, you can craft your own spells, or brew your own potions with ingredients found growing throughout the world. There are nearly a hundred base item types, most of which have enchanted/special variants and all of which have the ability to be enchanted by the player in innumerable ways. The world is about 3 miles across, and is packed with atmospheric details like rain, day/night cycles, duststorms, snow, and various degrees of foggy/clear weather. The landscape is dotted with tombs, grottos, mysterious industrial ruins, imposing strongholds, shipwrecks, caves, and demonic temples. There are perhaps 50 different creatures, ranging from adorably weak larva and mudcrabs to undead warlocks and dinosaur-like predators. Dozens of diseases can be caught, with cures that range from despicably easy to downright impossible. You can become a vampire and, if you get the GOTY edition, a Werewolf. Add in over 400 unique quests, numerous factions and guilds with agendas to pursue, and innumerable character variations(hmm… I wonder what would happen if I played a Khajit who always fought completely naked?) and you have a game that offers potentially unlimited possibilities and replayability. And although the quests themselves don't measure up to what you'd get in a game like Baldur's Gate, they serve as a nice blank canvas for all this emergent fun. It's not an RPG that's concerned with being immersive or "living." So no, nobody is going to walk up to you and ask you to do something, because everyone is too busy standing around.
And EVERYTHING is stat-based in some way, which makes character building extremely important. Luckily, the game also makes character-building fun in itself...and this is coming from someone who usually hates that part of CRPGs. There's also the infamous "level up by doing" mechanic that most TES games do... which you either love or hate. I personally love it.
There are guilds, yes. Joining them doesn't hold much weight, and you don't end up really feeling like you're part of a special group or anything, but it's kinda fun to advance within the ranks to open up more quests. There are also other groups you can join, as well as temples and "houses."
As a previous poster said, it's mostly a question of whether or not you can put up with the oldschool RPG mentality (stats stats STATS!), or if you prefer the more cinematic action-y feel of modern RPGs.
EDIT: oh yeah... and I should also mention that the game just BEGS to be exploited. That's all part of the fun.
Post edited February 05, 2012 by jefequeso