To be honest, I'm quite open when it comes to style. Either it be old school top down type games or the (now) more commom third person types such as Mass Effect etc. Provided it offers an engrossing story, depth of character development (pc and npc) and a rich world / environment in which to explore. For want of a less nerdy explanation, I like RPGs which engross you in the story in a similar way to how a book does.
Although nothing like TW3, I wouldn't mind trying some of the more recent Final Fantasy games. Are any of them (with the exception of 7) worth playing on the PC?
There are so many great games that cover these bases.
Some of my favourites of all time (in no particular order, these):
Deus Ex (the original) - not a "pure" RPG, but an amazing story and world and lots of options for building your character through augmentations. Incredibly engrossing if you can get past the now dated graphics. Still ranks as the best game I've ever played.
Star Wars KOTOR I and II - ditto, although given the style of the game the old graphics are less jarring.
Baldur's Gate II - ultimate old-school high fantasy adventure D&D. There is a remastered version available although the graphics still look quite old.
Planescape: Torment - best story of all time for a game imo. Again, dated visuals, but I don't think it matters in this type of game.
Gothic 3 (with the Ultimate Community Patch) - one of my favourite OTS fantasy RPGs.
Morrowind - best of the Elder Scrolls games for me. Again, there are graphics mods that make it look more palatable.
Neverwinter Nights (particuarly Hordes of the Underdark) - HotU is a great expansion for a decent enough base game. Classic D&D stuff.
NWNII (with Mask of the Betrayer) - MotB makes the second NWN game for me.
Some more recent ones:
Divinity: Original Sin - I love the way this brings the old school style up to date, both visually and with its own take on combat. A large, lovely-looking world, lots to explore, collect, craft.
Pillars of Eternity - plain looking I guess, but a throwback to the old Infinity Engine RPGs of old.
Kingdoms of Amalur - somewhat under-rated. Not Earth-shattering I guess, but a solid RPG with a very large world to explore.
Two Worlds II - I really enjoyed this one. It's not everyone's cup of tea, but it also has a large world, liberal use of humour and lots of quests. What made it for me what the unique magic system as I like playing magic users and this alone made it one of the most interesting RPGs I'd played. If you're not a fan of magic though, there's less to recommend it.
Alpha Protocol - again a bit under-rated for me. Brings stealth RPG to the espionage genre. Not too long either, so you could actually finish it in a weekend.
Dark Souls - a very action-oriented RPG, but in an amazingly created world. Tough as old boots, but rewarding for it. The raw feel of the world is excellent, and there are some of the most memorable boss fights in all RPG-dom. Lots of ways to spec your character for a different way of playing too.
You might also consider Dishonored. It doesn't qualify as an RPG and you don't explore too much, but the world it creates is genuinely intriguing and memorable.