If you are looking for a fairly linear rpg with set story options, I can't personally provide many suggestions in that vein of the genre.
1. Borderlands. Magitech fantasy, multi player. This game is highly quest and story driven. Really, really. It can be played over LAN.
2. Drakensang. High fantasy, single player. Quite enjoyable, (I believe) German game.
If, however, you are looking for a "sandbox" rpg with limited forced story, I have a few suggestions:
1. The Elder Scrolls 4: Oblivion. High fantasy setting, single player. This game is really fantastic. Graphics-wise it can be so beautiful but will also run on lower-end pc builds. The game right out of the box (you see it referred to as vanilla Oblivion) is quite fun, but once you get tired of the muddy textures and empty landscape you can turn to the modding community for their expansive content.
2. Ultima Online. High fantasy setting, mmo. This is a 2.5 dimension game with mediocre graphics, but it has the best mechanics for an mmorpg I've ever experienced. Official pay to play servers are still being run I believe, but they may not have much in the way of support or events.
3. Fallout 3. Apocalyptic fantasy, single player. This one is great if you like guns and dingie-ness. I'm pretty sure the entire game world is covered in a thin film of icky. The story is slightly more linear than an mmo or Oblivion, but it's still pretty much choose your own.
4. Dragon Age: Origins. High fantasy, single player. I haven't actually played this game, but I've heard lots of great things about it. I'm really really looking forward to trying it. It's also modable and already has quite a following.
5. Ragnarok Online. Fantasy/Steam punk, mmo. This is a simple, fun, 2.5 dimension mmorpg. Limited character customization, and really simple level and stat advancements. Most of the "quests" are kill a monster for loot quests, but if you meet a couple of cool people it can be really fun to go kill monsters together and gain levels.