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
Last of Us. Outside of Elder Scrolls games I had never played a game that you had to invest time into. I remember after >!Tess sacrificed herself to save Joel and Ellie!< I was thinking that I was near the end of the game and then I realized I really was just getting started.