For me it was Okami. I remember you do a ton of shit to get to a certain boss which I thought it was the end, only for it to reveal that there was a loooong path ahead.
Other than that, maybe cyberpunk? I was surprised after all that stuff you do in the beginning just to see the titles pop up
GoW 2018 and GoWR did this really well.
Also Mass Effect 2 and Mass Effect 3.
Marvel’s Spider-Man and Marvel’s Spider-Man 2.
Halo 2
Witcher 3