The game that has probably stayed with me most is Ocarina of Time. It's flawless IMO.
Other great games:
Chrono Trigger
FF6
RE4
Dark Chronicle
Max Payne
Legacy of Kain series
MGS series
Devil May Cry
Civilization series
Half Life
As well as others I'm probably forgetting.