I shoot a fair amount with a 105 mm macro. My images are generally in the range of what you want to do. The 105 mm is a magnificent lens and it does put some distance between me and my subject. When I use my film camera I find it to be an ideal lens at an ideal distance. When I shoot digital (half frame) it is idea for small flowers but when I shoot a large flower I find myself so far back that often I am in an adjacent flower bed. The way I shoot the 200 mm would be way to much, I suspect I would have to step back to Toledo to photograph tulips Nova Scotia. If I was buying my first macro for a ½ frame dSLR I would consider the 60 mm as well as the 105 mm but not the 200, unless your wanted close ups of venomous snakes. Don’t forget on a ½ frame dSLR the 60 mm will behave more like a 90 mm and the 105 mm more like a 160 mm and the 200 mm will behave like a 300 mm. The 200 mm will give a lot of distance between you and your subject and a shallower DOF field for the same image size. Believe me there is not much DOF in macro and often you are scratching for it, something to consider.

This is a Siberian Squill I shot a short while ago using a 105 mm macro.