Originally Posted by
DanK
I don't shoot Nikon, so I know nada about the Nikon lenses, but I do shoot a lot of macro, so I can chime in with a few things.
First, a lot of what is best depends on what you are going to shoot, but I can't think of any macro work for which I would buy a 40mm lens. If you don't have one specific use in mind, I second what Grahame wrote: 90 to 105 mm.
Second, for the most part, you needn't worry about VC, if your only concern is using the lens for macro work. Even apart from the fact that a lot of macro work uses flash to freeze motion or a tripod or monopod, most VC systems correct for rotational motion, which becomes less and less important as you get closer to the point of rotation, i.e., the camera. In contrast, as you get close to the camera, motion parallel to the sensor becomes MORE important. The problem is that very few lenses correct for the latter type of motion. I may be wrong, but as far as I know, only Canon's hybrid IS does, and that is available only on a few of Canon's lenses (and only one of Canon's macro lenses, the 100mm L).
Third, while I have used only Canon macro lenses, all of what I have read indicates that most dedicated macro lenses are very sharp. The reviews of the Tamron and Sigma lenses have been very good. The main differences are other features. E.g., does the lens extend? Does it provide full time manual focusing? How good is its AF? (With respect to the last, while most macro is not done with AF, I do sometimes use it, in particular, to get an approximate focus, after which I move the camera to try to get fine focus and track the bug.)