That should magnify the object. "True macro lenses offer a magnification factor of 1.0x or 1:1 at its closest focus setting." from http://www.digitalcameraworld.com/2013/08/23/what-is-a-macro-lens-magnification-minimum-focus-distance/
Since you listed 100 and up mm lenses these appear to be magnifying quite a bit. I own a Canon t3i and the 40mm lens so while USM is a nice touch, for macro I don't think it's required. What do you think?
1. Tamron Telephoto SP AF 180mm f/3.5 Di LD IF Macro Autofocus Lens for Canon EOS
2. Sigma 180mm f/2.8 APO Macro EX DG OS HSM Lens (for Canon)
3. Canon EF 100mm f/2.8 Macro USM Lens