Nah, not in the way they did. I legit salivated over the early PS2 screens... I hoarded NextGen mag and stared at those blown up 480p ps2 screens all day.
I'm still impressed by great looking games like Red Dead 2, but now art direction kinda matters more to me than graphic prowess. Art direction always mattered of course but a game could simply wow me on the tech alone in the past and now that's not really my thing anymore. There's still games from the past that I think have great art direction and pretty lousy technical graphics that I think are stunning. GTA San Andreas fit that for me, a technically ugly game but with terrific art direction on the things that matter to me and an old GTA SA screen will catch my eye and I'll remember how great looking a game that is.
When new consoles come out I'm rarely stunned by the graphics as I was with the leap to PS2. I lived thru 8bit to 16, 16 to 32/64, and then all of the others since, and that PSX to PS2 was just such a huge jump. Madden 2001, MGS2, Dead or Alive, Midnight Club, handful of other early games were like something I'd simply never seen before. The jump to 16bit was important but late NES games looked really good, compared to early Genesis games. Sonic wowed me at a friend's house but more the sense of speed and color palette. I wasn't really into graphics until I knew that graphics could be a differentiator in games. PS2 came out at a time when I was really into the technology of gaming too, I was 16 or 17, had built PCs for gaming and was really into the technical side at that point.
I think another change since then is that PC graphics started to consistently get out in front of consoles for all genres of games and they sort of prepared me for what is coming. PS2 really was doing things I'd never seen before even on PC (I was an avid PC gamer at that point).
Most recently I've thought Control looks great on Xbox Series X. And aforementioned RDR2 which still is the most graphically impressive game to me. But there's very few games that really do it to me like *most* new games did back in the early PS2 gen. There were games I bought for PS2 that weren't even genres I liked but just because the graphics were so good to me. That's not the case anymore for me. I'll never buy a game based solely on graphics, something I did more often then.