If you want to go ancient, Betrayal at Krondor (available on gog.com) is an excellent game so story driven that you can't even choose the party members because they are part of the story.
I don't know if I love this game because it's so good or because of the good memories.