While I really like all of the games mentioned above, my absolute favourite is Planescape: Torment. The story is incredible, the characters are intriguing, the atmosphere and music grab you, and the spells and enemies are incredible beyond description.
How can you not like a game in which this is the main character:
Threaded Mode
