The brazen bull or scaphism. Both are long, drawn out and incredibly painful. Boiling is up there too. An oubliette with rats or mice. I would take the stake or drowning before any of those. The brazen bull or the oubliette are definitely the worst ways I can think of to die. Scaphism is utterly disturbing, but not as terrifying to me for some reason.