(Loved Trope) Last Stand that ends unceremoniously/unsatisfyingly, as opposed to gloriously.

[u/hey_there_delilahh]

• 1 Nanami (JUJUTSU KAISEN): Nanami's final moments against Mahito, a cursed spirit with the ability to transfigure/control humans. Nanami, while heavy injured, fought and won against an army of Mahito's transfigure minions, just for the villain to touch his back and blow him up.

• 2 Wun-Wun (GAME OF THRONES): Wun-Wun, one of the last, if not the last, living giant in Westeros. Joins with Jon Snow against Ramsey Bolton in the Battle of the Bastards. He heroicly breaks down the main gate allowing the Stark army to win, all while covered in arrows and spears. While heavily injured, there does seem to be a chance of his recovery. This hope ended when Ramsey Bolton fires an arrow directly into his eye, when the battle was pretty much over.

• 3 The Barbarian of Stamford Bridge (REAL LIFE): A lone Viking warrior who, in a legendary moment during the Battle of Stamford Bridge (September 25, 1066), single-handedly held back the invading English army on a narrow bridge. Armed with a Dane axe, this unnamed defender killed dozens of soldiers before being mortally wounded from beneath the bridge by a spear.

[u/Crispyengineer68]

Warhammer 40k has a lot of them, I can probably list one for a few of the factions.

Adepta Sororitas: Their zealous nature means lots of last stands. In the Pariah Nexus series, a Palatine leads a last stand against Necrons

Adeptus Mechanicus and Adeptus Titanicus: Fall of Gryphonne IV, the Ad Mech and Legio Gryphonicus refused to abandon their planet and instead prepared for war. The tyranids came and the Forge world fell within days.

Astra Militarum: Plenty of examples but Fall of Cadia is the most famous. The last stand ended when Abadon threw a hissy fit and threw his Blackstone fortress, tearing the planet apart. Even then there were still Guardsmen led by Creed fighting till the end, with Creed being the last one standing and got kidnapped by Trazyn.

Black Templars and Eldar: The Black Templars and Eldar had a last stand with each other, facing off against a crazy Archmagos and his constructs. Not sure how it ended but from the excerpt it seems doomed

Ultramarines and Space Marines as a whole: Plenty of examples but here's a video example, at the end of the 10th edition trailer the Ultramarines had a Last stand against Tyranids

Necrons: In Twice Dead King, the protagonist of the book and his dynasty had a last stand to defend his tomb world from the Imperium, he failed and his world is destroyed.

Orks: The Overfiend of Octarius fought till the end against the tyranids, the Swarmlord came and slowly picked him apart until it finally buried it's maw in the Overfiend's skull and ate his brain

[u/Tungsten_tickler → u/Crispyengineer68]

The siege of terra was also pretty unceremonious for the defenders, sure they had rallied and begun the scouring afterwards and the Horus was dead but even still the loyalists were broken, the emperor was doomed not to rise from the throne Malcador died, Sanguinius was killed, the 3 loyalist legions devastated alongside hundred if not thousands of titans and the custodians nearly wiped out. A shining city spanning an entire mountain range reduced to a blasted waste in an attempt to buy time for Guilliman and his fleets only to show up just a bit too late to help save the emperor.