Peasant's Quest, by the homestar runner guys, has some pretty amusing death scenes -
type "die" and you die
Walk to close to kerrek and you die
Jhonka asks if you stole his riches. If you say yes, he kills you. If you say no he says "oh, okay"
Trogdor's guardians all kill you in inicredibly amusing ways if you get thier questions wrong "You must play music for all time" and "As punishment, you may no longer have skin"
Of course, even though I haven't played it yet, Maniac Mansion probably has the best death scenes [or so I'm told], from what I've heard, involving the microwave [Radioactive Steam and frying the rabbit]