A bit of a potentially controversial title I know, but now I've got your attention perhaps you can hang around and answer the question...
When I say "failure" rate what I mean is how many good images do you get to blurred, out of focus, "where did the subject go?" shots? The thought came to me when I was trying out a new flash set up for macro and was chasing bees around the cherry tree. Every time one landed I moved into a relatively close position, desperately find the right focus distance, set the aperture (manual lens, I need to see enough detail to focus then wind up the aperture to get a decent depth of view...) and shutter!.
Trouble was after a number of shots that would have exceeded the maximum number of images on two rolls of 35mm film (thank you whoever made digital photography) I got maybe one decent image and a couple that weren't that bad if I worked on them. Not to mention the number of times I got to step three or four and the bee decided he'd move on elsewhere...
Which made me wonder how everyone else got on? Obviously there are photo-gods and goddesses out there who get great shots every time, so maybe the question is what would you class as a "successful" shoot in terms of the good to bad ratio? I'd be particularly interested in any other macro enthusiasts and see how they get on.
Cheers