So I decided on the Canon EF-S 60mm f/2.8 Macro USM for shooting the artwork. It is really nice and takes great shots with little distortion if any (haven't test it much yet). But I'm surprised how far away I have to be from the work. Even small work I'm set well back.
What would be the difference with the Canon EF 50mm f/2.5 Compact Macro? It also has flat optics but shoots at 1:2. So does that mean the camera would be closer physically? Or should I be looking at the 100m Macro instead?
The reason I'm asking is I found a heavy duty tripod that can mount the camera upside down, so for a lot of the work I can set it up as a large copy stand. But with EF-S 60mm it would limit to mostly the smaller subjects, so perhaps the compact macro would be a better option?
That being said the EF-S 60mm Macro would be great for standard tripod shooting because it'll give me a bit more room front of the camera for when I have to maneuver and adjust lighting, etc..