I just delved into that world. I have a Nikon 105 2.8G Macro and I do like it. But I really wanted to try to get shots of fly's compound eyes and everything. I could never really achieve that with the 105. But it DID give me good working distance.
I'm now trying a 24mm 2.8D reversed and kenko tubes... those give you incredible close ups but lack working distance and you need lots of light (at least with the tubes). Someone posted a macro video here of a well known photographer and in some of the shots he is about a cm away and I'm scratching my head thinking how he gets so close.
I think my gallery might have a couple of insects with the 105 but I haven't posted anything with reverse lens. I can get some really good closeups with reverse lens and reversing with tubes is extreme close. But there's a ton of technique involved to get proper DoF and lighting. I might have to build something to diffuse my speedlight to give proper lighting. It's going to take a lot of practice I can tell. Using a tripod (although not possible for some shots) would be optimal because reverse lens with tubes needs so much light and you lose so much DoF that you need an appropriate aperture.
If you have a D lens I'd try an adapter ring with a 50mm or 24mm and see what kind of shots you can get. The 105 is a fine lens but I'm not so sure how "close" you can get. But hey... what do I know.