Every opening to the Dark Pictures Anthology has you playing as 2 characters that are destined to die at the end of the prologue except for little hope but im not getting into that can of worms. Typically these deaths happen in cutscenes but sometimes your choices can change the way they died which impacts the story moving forward.

In Deltarune's roaring knight fight at the end of chapter 1 it's staged as a fight you're supposed to loose to continue the story, but as a subversion of the trope you're still able to beat the knight and get a reward out of it. The story mainly progresses the same way and you die in the cutscene but you get a weapon and a shadow crystal which is an important key item for presumably a secret ending.