Might as well list everything from BioWare and Obsidian/Black Isle. Baldur's Gate 1 and 2, Planescape: Torment, KotOR 1 and 2, Mass Effect 1, 2, and 3, Dragon Age 1 and 2. Though BioWare is a bit better with character presentation and development, but their plots are still good

Alan Wake would be an interesting example though. It has a good story, interesting and believable characters, and its actually about a story writer and his story