Well I only play 4 games Wizards and Warriors, Baldurs Gate II, Majesty, and Lords of Magic.
My favorite can be guessed very easily Wizards and Warriors.
But I play Majesty because it is very challeging and never the same. Lords of Magic is an Online game. But you don't have to play online it is also offline. I have played a game where it is only online and I don't like those kind of games. But lords of Magic has several had quests and Is even more challeging. I play baldurs gate and don't like it much I only play when I am in the mood.
But I would Recomend Lords of Magic. Online fun and you don't really need any advice in it. it is pretty much all told in the instructions. And Boy do I love that game. In fact I just got done playing it before I got onto this site. I wouldn't classify it as role playing though but it is still very fun.
Oh ya did I mention there is really no ending to it. and there are unlimited save files. All of my friends who don't like RPG's all like Majesty and Lords of Magic I made them buy them.
Majesty comes with an expansion. and has a form.
the link is right
here. You can download a demo for it. And you can also download extra quests.