Morrowind is really an extremely great game, but I don't know if RPG is your genre. Some "casual gamers" get scared away by the big world and possibilities. That's just one big pro for me though.
I guess Morrowind in short has got a really, really great atmosphere (the way the world is built + the story backing things up is very epic and beautiful), a story to completely drown in and a pretty good and diverse gameplay.
I won't be able to like it like I did before, because of nostalgic value and because it's really outdated at the moment (graphics, gameplay, everything), but you might like it.
edit: In the case you want something more modern, Oblivion is a good alternative obviously