Joe Pesci in Casino was an interesting and rather disturbing demise.
The dude in A Nightmare On Elm Street that got turned into mushy liquid on his ceiling is one I remember.
Also I remember Andy Garcia getting decapitated in Black Rain by a rather sharp katana... Ouch!
