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
Spoilers for Far Cry 5:
Technically the ending of Far Cry 5 counts, Joseph Seed, the leader of the cult, Project Edens Gate, was herding people into bomb shelters for the “Great Collapse”. At the canon ending of the game, a nuclear bomb fell. The game ends after Joseph Seed carries you to a bunker. However, there was supposed to be content after the bombs fell, but it was cut from the game. Welcome to Far Cry: New Dawn.