Half-Life 2, Ep1 & Ep2
Indigo Prophecy (aka Fahrenheit)
Legend of Zelda: Majoras' Mask
Bioshock
Ico
Shadow of the Colossus
Silent Hill 2
Call of Duty 4: Modern Warfare

I think the reason that many games that are going the way of cinema is because it brings you in more. When a camera is just still looking at a persons face as they talk it is awkward. The same way a good cinematographer can immerse you into a movie, a good looking game can do the same.
All of this is without considering the actual story, that would be a different discussion.

THANK GOD!!!!!