GP,
Wish I
could recommend a good lens - I
can offer hope, though, that you'll be able to get a good shot: This is taken through a loupe (magnifying lens) held over the front of a Fuji S3100. The bee was crawling through the grass, so I'm guessing it was stunned by flying into a wall. I put a dandelion in front of it, it latched on, and I shot until it felt better and flew away. Luck plays a part sometimes!