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
I was fully convinced I haven’t had a single experience like described above, but yeah, Nier Automata does kinda fit the bill.
But even there I was told in advance to “keep playing”, not spoiled, not really, but there obviously was no “woah, mind blown” effect when you just play slightly changed ng+. The mindbender came after that playthrough and the rest really doesn’t work as “this was just beginning”; you’re through a huge chunk of the playtime at that point.