The most notable difference relevant to macro photography is that a 100m lens will offer a larger working distance between the lens and subject than a 50mm. That means you will need to stand further back with the 100mm, but this prevents scaring off subjects like insects or other small creatures. And it provides room for lighting equipment if you need it. But, the 100mm will be larger, heavier, and pricier than a 50mm lens.