I played Horizon Zero Dawn a year after it released and had this reaction. I guess getting my plat in Demon Souls is a more recent example.
But honestly, the biggest suprise to me was Gears 5 when I got my Series X. I had heard so much crap from haters, that I was genuinely suprised how great the game actually was. Don't get me wrong, it wasn't perfect...the open areas in general with the glider needed a bit more to them. But from visuals to gameplay, it was a great experience for me that I did not expect before hand.