When you start working in the realm of macro, magnification becomes the primary consideration.
If you want to have that half inch long insect fill up a half inch long image on your negative, you need a lens and system that will give you 1:1 (life size) magnification.
To achieve that, if you are using an unmodified* lens, you need a lens and camera combination that permits moving the lens' nodal point to a distance from the film plane that is twice the focal length of the lens.
That movement of the nodal point will focus the lens at a particular point. The distance that that plane is from the nodal point is a function of the focal length of the lens - a 100mm lens will focus to life size magnification at a distance that is farther away than a 50mm will focus to life size magnification.
What would the advantage of a 50mm macro lens be compared to a 100mm macro lens? Potential lower cost, smaller size when focused at more normal distances and, in some cases a closer working distance (when the desired perspective that arises therefrom is sought).
*I make reference to an unmodified lens, because one of the ways of achieving higher magnifications is to "modify" it - insert higher magnification into the system optically. You can do that if you either add close-up (diopter) filters at the front, or tele-converter elements at the back. When you do that, you can achieve more magnification without reducing your working distance as much.
If you want to have that half inch long insect fill up a half inch long image on your negative, you need a lens and system that will give you 1:1 (life size) magnification.
To achieve that, if you are using an unmodified* lens, you need a lens and camera combination that permits moving the lens' nodal point to a distance from the film plane that is twice the focal length of the lens.
That movement of the nodal point will focus the lens at a particular point. The distance that that plane is from the nodal point is a function of the focal length of the lens - a 100mm lens will focus to life size magnification at a distance that is farther away than a 50mm will focus to life size magnification.
What would the advantage of a 50mm macro lens be compared to a 100mm macro lens? Potential lower cost, smaller size when focused at more normal distances and, in some cases a closer working distance (when the desired perspective that arises therefrom is sought).
*I make reference to an unmodified lens, because one of the ways of achieving higher magnifications is to "modify" it - insert higher magnification into the system optically. You can do that if you either add close-up (diopter) filters at the front, or tele-converter elements at the back. When you do that, you can achieve more magnification without reducing your working distance as much.