I don't like "weak deaths", stupid on the other hand, let the one who begs it get it.
When I do like "weak deaths" or dramatic, is when I don't like game, or my character and want out, from either of them. Character death is good way to "fade out".
I've witnessed many "bad dice" deaths...