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
The start of Raiden’s adventure in Metal Gear Solid 2. After having played through the tanker as Snake, there’s suddenly an entirely new part of the game.