Source set a new bar. Left 4 Dead 2 still looks great despite being over a decade old (we're coming up on the first game's 20th. birthday). Part of that was how Source did textures and it used a lot of them.

Since Source, I can't think of anything that had that much of an impact. Unreal 5 looks decent enough, but it's not like the jump from Goldeneye to Day of Defeat.