I still think Shadow of the Colossus on PS2 is one of the best looking games out there, even though it was going for a more realistic art style which has aged horribly in most other games.

For a contemporary example, Hi-Fi Rush. Here in 20 years, when modern graphics look like ass by comparison, heavy stylization will always look good.