PS2:
Silent Hill 3
FF12
God of War II
SMT Nocturne (actually also was pretty impressive)

Gamecube:
Resident Evil 4.