The last time I recall new graphics blowing my mind was probably with the pre-rendered era: Donkey Kong Country, Myst, FF7, and Resident Evil 2.
N64/PSX to Dreamcast was probably the last jump I really cared about. The jump from Dreamcast/PS2 to Wii/PS3 was not even close to as impressive. The main problem with older generations is that they don’t always translate well over to more recent screen ratios and resolutions. But other than that, I don’t see as substantial a difference between games of 2001 and 2020 as I did between 1988 and 1992, or 1992 and 1996c or 1998 and 2001. Those were all gigantic leaps, that doesn’t happen any longer.
You should play death stranding, graphics blew my mind several times. It's gotten to a point where it feels like that what's behind the screen is real and breathtaking.