You could a colony of European paper wasps nearby u do a live shooting, as they are relatively docile.
The best time to shoot them is early in the morning when they are still a bit sleepy are
Or, you can put out food that they want
Unfortunately I have not the equipment for super macro shots; I am limited to a crappy dioptre. One of these days I be able to afford a decent macro lens …