Halo: Reach - Lone Wolf: Noble 6 performs a final stand against The Covenant as the UNSC Pillar of Autumn makes its escape before the planet's glassing. There is no way to survive the overwhelming swarms of Elites rushing in and sooner or later, the player will die. If one is skilled enough (or bumps the difficulty down to Easy), they can earn an achievement called One Last Firefight for earning 150,000 points during the entire survival segment, which can take past an hour to do so.
Red Dead Redemption - The Last Enemy That Shall Be Destroyed: John is attacked in his own homestead by an overwhelming amount of U.S Marshals under the orders of Edgar Ross, who chose to dishonor the deal he had made with him and have him killed off for being part of the Van Der Linde gang after all. Knowing there was no escape for him, John sends his family off on horseback and buys them time by staying behind to fight the government men himself. The player then can activate Dead Eye to take down as many agents as possible, but no matter how many John manages to kill, he will be subsequently gunned down.
Left 4 Dead - The Sacrifice: The final campaign for Left 4 Dead 1 is The Sacrifice, where the Survivors finally manage to find a sailboat they can use to escape the apocalypse on an island. However, they must first raise a bridge to get the boat through so they can escape. Whilst raising the bridge, the final generator jams and only one Survivor can go back down to turn it back on, which will spell out certain death for them (which canonically has been chosen to be Bill). Whoever chooses to sacrifice themselves can try to survive the incoming horde as much as they want, but they are dead as soon as they step off that bridge.
Cyberpunk 2077 - Don't Fear The Reaper: The secret method of storming Arasaka Tower, often considered by many the canon choice, purely because of how awesome it is. V and Johnny, realizing that they're out of time and (depending on how you played) out of options, decide that the best course of action to finally get into Mikoshi is to simply blitz through Arasaka's front door and fight their way inside, or die trying. It is a suicide mission in every sense of the word, because if the player dies at any point during this mission, they are earned with the same ending that they'd otherwise get for choosing the game's Suicide ending. However, if the player succeeds in not just fighting through Arasaka's forces, but also Adam Smasher himself, they earn special variants of either The Sun ending or the Temperance ending.
Halo 2 - Noble 14: An interesting meta example. When it was announced that the Halo 2 multiplayer servers were about to be shut down for good on April 16th, a bunch of fans got on to play the last few games they could. However, when the service was finally officially shut down, they quickly discovered that the lobbies they were in remained open so long as they didn't log off. As such, the final remaining 14 players attempted to keep their Xboxs on for as long as possible, not allowing the game to die up to May 11th, almost a solid month after the game's servers were supposed to close for good. And the only reason the last two disconnected was because they were manually booted offline by Microsoft.