Veylon said:
Most of the games in the middle-to-late sprite era still hold up. There was just a bad gap about ten years ago where 3D was still catching on. There's only a few, like Mario 64, that made the limited polygon count into a style instead of being confined by it.
Have to agree with the sentiment here. By the time 3D came around the technology was already there, and had been for some time to translate some great looking 2D art styles into a game. So stuff like the SNES Final Fantasies, Chrono Trigger, Super Metroid, Super Mario World, Yoshi's Island, etc. that all had really great art direction weren't hindered by the technology of the day, while early 3D stuff was constantly bumping up against the limits of the technology of the day.
That said, there are still great looking early 3D games that are still great looking because, like you said, they had an art style that worked well within the limits of the technology. Super Mario 64 being a great example. I'd say Mega Man Legends is actually another that works well for similar reasons, and certainly the PSX era FF's, particularly IX, and the Resident Evil games all looked great and hold up fairly well all things considered, in part thanks to their use of pre-rendered backgrounds. On the PC end, stuff like the original Quake still looks good as well.
Last gen is really where 3D started to come into it's own though. Games like the PS2 Gran Turismo's, MGS2 and 3, FFXII, Prince of Persia, Silent Hill 2, 3 and 4, Persona 3, Ico, Shadow of the Colossus, Jak and Daxter, Wind Waker, and a hell of a lot more still look great. And while not really 3D, I have to give a shout out to the 2D in Odin Sphere and Grim Grimoire. And of course this generation, we're no longer really facing the sort of limitations we used to. At this point, short of making a massive open world game, it's hard to push the hardware so hard that it limits the art style a company can use.