Not a movie, but historically I think the (Catholic) Church has come up with some pretty good ones. Some of their more tame methods included burning at the stake but when you take a look at mediaeval instruments of death (all in the name of religion) you begin to understand that unchecked, mankind can be pretty fucked up.
Yup used a lot of those implements on so-called "witches"
Calloway, American History X was a great movie, that death scene made me cringe. Personally if they were gonna pick a "Best Worst" death scene for Full Metal Jacket I would have picked the death of the sniper at the end.... eerie and yet wicked.
How about in Blackhawk Down when they're digging around inside that guy's leg trying to clamp a severed artery because they've run out of IV fluid? Guy is fully conscious of course. And for the retro crowd, how about after the chariot race in Ben-Hur where the guy has his legs crushed to pulp? Pretty gruesome for the 1950s, especially the seizures.