Lots of FPS and some heavy story based games in here! I'd like to add Planescape: Torment (unless I missed someone mention it already!).
Probably the best narrative of any game I've played on any system. If we include all books and movies and music it still ranks within the top 5 of top media...