>>2712554>>2712540Dedicated macro lenses will get you get you "closer" to the subject, it will appear larger and you can see more details (see example).
The focal length will primarily affect working distance for a macro lens. As in, a 150mm macro and a 50mm macro will show a quarter the same size, just with the 150mm you can physically be further away (useful for stuff like bugs).