AAA games from 2002+ still look good to me. They have enough graphical fidelity to me that even games that attempt to look realistic aren't particularly shocking to me. Games from 1960 to 1996 also look great to me. Sprite-based shooters and such and 2D games age well to me because they were never meant to look realistic, and so they can't really age. That's why retro-styled games from today are still fine. And yes, I do include games like Civilization, I include Atari 2600 games and Ultima I-VI.
The games that don't look quite right anymore are from that awkward, plastic era where we wanted to make realistic-looking games but weren't quite there in tech IMO. These are Half-Life, Deux Ex, Daikatana, and many other games that I can't think of off the top of my head that aren't necessarily FPSes.
I'm just wondering how long it takes before we start to recoil away from Crysis or The Last of Us because those are too plastic-y looking.