The last console game to really blow my mind graphically was Uncharted 2 in 2009.
Yeah, that was the one I was going to mention. But mainly because of how much had been improved from the first game in just two years. If I had not played Uncharted 1 first, I probably wouldn't have been as surprised by what I saw. But I still remember being amazed at the trails you could leave while dragging your feet in the snow in the opening sequence for example.
I actually hadn't played Uncharted 1 at the time, though I had seen footage/screens of it online. I'd dabbled in a little Xbox 360 IRL, and been blown away by Gears of War 1 and later very impressed by the likes of Bioshock and Gears 2. Uncharted 2 though, once I saw it firsthand on a friend's PS3, was on a whole 'nother level. The sheer density of detail, the lifelike animations, the scope and complexity of the big action setpieces, it was just astounding.
Nothing since has quite recaptured that feeling, though as I say Metro Exodus PC maxed out and raytraced comes close.
It's not that there haven't been games besides those two in the last decade that impressed me graphically, just nothing else that has really made my jaw hit the floor.