Horizon Zero Dawn reached a point where I think that it will always be consider a nice looking game.
Its very consistent and stylized.
Since Much118 just posted them in another thread, behold:
This will never not look good.
Wipeout Omega Collection will also hold up till eternity.
I don't think Uncharted and God Of War will hold up as well as these.
Parts of God Of War will hold up, but the game is not as consistently good looking as Horizon for example. Same is true for Uncharted.
Timelessness of visuals depends mostly on the artstyle. Consistency is key.
The more a game is trying to imitate realism the harder it becomes to consistently reach a certain level of realism.
Horizon is what I thought of when I read the thread title and those gif's reinforced that notion. There's something about the style of that game that will hold up well I think.