My vote for most gruesome fatality in a DMD is the guy getting his head blown off when the letter bomb blows up in Dirty Harry. Kicking ass in Barroom Brawl is pretty cool too... like when you smash a guy over the head with a chair.
Any other games with sick dots?
Judge Dredd has an old lady getting mowed down in the match sequence. But I think she lives.