As both player and DM I've seen deaths horrible, humourous, futile, pathetic, heroic, and - well, amazing. A few follow:
Amazing: in the 1e-based campaign I'm running now a character got cut off from the main party by a group of wights and was sinking fast. He'd lost all his levels (so was just a 0th-level commoner) by the time his initiative came up, so with a cry of something like "so you don't have to see me again!" he used his attack to run himself through and commit suicide; this to prevent himself from being killed by the wights and thus rising as another wight shortly after.
Amazing: in a campaign I played in the party was getting seriously clobbered - of something like ten of us there were two or three still alive, all sinking very fast. We knew from prior information gathering that a particular suit of armour somewhere in here had a ring of wishes built into one of the gauntlets, so a dying character (ignored by the enemies) crawled off to look for it. It was in fact just a room or two away, yet by the time he found it he was our last survivor; though the enemies weren't in much better shape. He got the gauntlet on, used a wish (the last one in the ring, as it turned out) to revive the rest of the party...and then himself died.
Humourous: one of my characters in a campaign I'm still in had fighting-retreated herself into a small dead-end passage off a larger chamber and was badly outgunned by her foe, so she went for broke and hauled out her wand of wonder. There wasn't nearly enough room in that little passage for both my character and the elephant she summoned...
Futile: in my previous campaign the party met a beholder. Party's Dwarf gets its death ray, needs a natural 3 to make his save, rolls 2 and dies. Party has field revival available so they grab the corpse, bail out, and revive him a bit later. Next day they go back in with more preparation. Same beholder. By sheer bad luck the Dwarf gets the death ray again, this time needs a 2 to save...and rolls a 1. Auto-fail, thus he becomes one of only a very few PCs to ever be killed twice by the same opponent.
Lan-"and there's a whole lot more where those came from"-efan