Yeah, Morte was a bit like that.
Planescape:Torment is my all-time favourite PC RPG... it can be compared to an adventure game (except for the combats, of course), because the storyline is really deep, and you get attached to the main character. It's become hard to find now (released in Nov. 1999). If you get the opportunity to try it out, give it a go!