Capcom's output on the PS2 still looks really impressive to me, DMC1 and 3, Haunting Ground, Resident Evil Outbreak 1 and 2, all gorgeous games to this day.
A lot of PS2 stuff holds up very well in general, especially other survival horror games like Silent Hill 2, 3 and 4, the Fatal Frames, Rule of Rose etc or games like Death By Degrees and Rygar The Legendary Adventure, the trick seemed to be simply fixed camera angles, lock the camera down and you could have crazy amounts of detail beyond a normal game that even 20 years later is still impressive.
Tecmo's Xbox output is still gorgeous, Dead or Alive 3, 2 Ultimate, X, Ninja Gaiden Black, all gorgeous games still.
And I'm still gaga for how many GBA games look, there's just something about how GBA did pixel art that still looks amazing to me, recently I replayed Aria of Sorrow and I think it still looks gorgeous, similarly I've been playing through the DS Castlevanias recently and they still look amazing too, as does SOTN, great pixel art is evergreen.