Well, Fallout I and II have great stories, but are set in a (non-magic) postapocalyptic earth.
If outdated graphics (VGA) don't matter, try
Betrayal At Krondor
Its a really great game with a story from one of the best fantasy authors (Raymond E. Feist).
Sierra even released it for free some time ago to promote the (not so good) sequel. So you can find it anywhere on the web. Just google it.
Also a great story has Planescape:Torment.
Unfortunately rpg's aren't what they used to be. Nowadays everything with swords in it is a rpg. I even read a review for a action game a short time ago, where they said it had a rpg-feeling, because you have swords and can collect healing potions
