Well First off I have to give props to areseris because system shock 2 has both an awesome story and narrative. but I also have to say why the hell hasnt anyone mentioned silent hill 2.
Of all the silent hill games (which have great story and narrative) silent hill 2 is the best. Personally I haven't a better story in any games except for maybe MGS 3 (which has been mentioned).
Definitely silent hill 2
Yes I am a fan of the Playstation 3, but I am an even bigger fan of intelligent and rational dialog. (If you are up for an intelligent exchange of ideas, you are more than welcome to add me as a friend)
PLAYSTATION®3 is the future......NOW.......B_E_L_I_E_V_E
(haven't been playing much since I am broke)