IMO a hornet sting is by far the worst. I have seen one sting knock a man down (not an allergic reaction). Big red wasps are next. I have been stung by all of them except a bumble bee as ours are docile and a lot are whiteheads that don't sting. I am sure there is a lot of regional variation.