Eric Brosius does a wonderful work in Thief 1, Thief 3, The Swat Games and some of Irrational's games.
Also, Mark Morgan has managed to do something in Torment which all other roleplaying games have failed in: He made epic music which is actually de-cheesy. Stunning, moving pieces, with original instruments.
Then there's The Longest Journey, Arcanum, Mafia, the Legacy of Kain Series. And Cannon Fodder