Yesterday when I was doing indoor macros, I got this shot, too. Not as satisfying, but it's one of the better indoor macros I've done.
click to enlarge, or see it on Flickr
Shutter Speed: 1/125
The flower area that I'm primarily interested in is sharply in focus. But the pollen is only somewhat in focus. This is, of course, a result of my f/2.6 aperture, but when I tried the same shot at wider apertures, I found I had the same problem. I discovered that the problem is actually my macro lens. It does great close-ups, but the widest depth-of-field I can get with it is roughly equivalent to f/2.8. So this may be another photo that requires two exposures with different focuses, and some careful masking in Photoshop, a la this post.