My biggest problem is ground bees. They are very small, very mean, swarming bees. I'm not allergic but my Wife is.
I generally locate the nest(after they settle down), go back at night, and pour dish washing soap down the hole.
I had one hive by my brush hog. I had to sneak in, put a strap on it and pull it away before I could use it. Then I forgot about it for awhile. When I came back later to kill them, I found that an armadillo had found the nest, dug down into it, and destroyed the hive. They also seem to dig into fire ants mounds. I need more armadillos.
At one time I had 20 colonies of honey bees and only one was a problem. It was a seriously mean bunch of bees. I tried requeening but couldn't catch and kill the old queen. I finally built a fire, suited up and tossed the whole mess onto it. Although it was my most productive hive, I didn't regret it.
For wasp nests, I shoot the foam stuff from about 10 ft. away. I have never seen a hornet nest.