Just be careful here... A lot of off brand (and some Canon) lenses are marketed as being "Macro"
True macro lenses will give you 1:1 reproduction or better. However, I have owned a Tamron 70-300 "Macro" which gave 1:2.8 reproduction. Not really macro, especially with a MFD of 0.95m. The 24-105/4L also purports to be a "Macro" lens.. not so much.
Agree with the above... you can't have true macro, short focal length and a wide aperture.
If you are shooting urbex aren't you using a tripod anyway? (I may be completely off base here...)
Mike



