Shit list and too broad a question. I like how Planet Harriers looks over those games, yes I am serious. I really like SEGA's crisp clean colorful look of their arcades and NAOMI/DC games of the era. TBH Ikaruga still looks great to me. Realism doesn't impress me. There is a reason Wind Waker and Okami still look incredible. Neo Geo 2D games still are impressive. Metal Slug still some of the best sprites ever. Streets of Rage 4 will stand the test of time. Terranigma. FF6 are still gorgeous games. Guilty Gear Strive blows my mind tbh. I thought Visions of Mana was great-looking this year. Same with Metaphor. Granblue Relink. Vanillaware games don't age. Odin Sphere. Dragon's Crown. Muramasa not aged a day. Realism only looks good for a moment but ages like milk every time. Shenmue was once the most impressive game to exist period but things age. Space Marine 2 looks incredible but it will age.

Cuphead.

On a purely superficial visual level, Cyberpunk 2077 is the best-looking game I've played.

Hellblade II for me, the sheer level of detail in its visuals is stunning.

^ So much CA.

Anyway here is a sprite from Metal Slug. More impressive to me than most modern games.

For me it's death stranding, followed by returnal.

Dead Space remake

Metal Slug animations are always next level, those are really peak Neo Geo and 2D pixel art

Returnal is an odd choice, I can see why though, like you can go up to an inch of the screen and the character model still looks as good as at a distance, no ailising, no loss of quality, none of that static fuss and it runs at a constant 60 fps even with none of that which seems rare and kinda the same for the backgrounds, I'd say playing this game on a PC would be amazing and you'd really notice how clean the graphics are. I'm only in the second biome so I suppose the environments later on might wow me but so far, eh. Inside of caves and a desert that's clearly a video game designed space. Eh. 

Another one that's right up there for me is Trine 4. It may not be a technical marvel, but its art direction is incredible.