A macro lens for the chosen subject will depend on your setup, working room and lighting. The different focal length lenses will have different close focus distances. You want to choose a lens that gives the focus distance you want to use.
Using 4 of Nikon's macros for examples. Other brands...