It took me a while to realize what I think you're asking... If I might, I believe that you want to know if the macro designation is going to effect the lens for general purpose shooting and the answer to that is no.
A macro lens, as Sigma is using it with this one, allows for closer focussing (rather than magnification). For example, that Sigma lens allows you to focus at something as close as 22cm (8.6 inches) away, while the Sigma 17-50mm can focus as close as 28cm (11 inches) and the Sigma 28-70mm can focus as close as 38cm (15 inches). Might not seem like much, but can matter, nevertheless, it only means something when the subject is close, it will behave no different when the subject is further away.
The comparable Canon lens, by the way, is the Canon EF-S 17-85mm f/4-5.6. Slightly longer zoom, smaller aperture throughout, and a minimum focussing distance of only 35cm (13.8 inches).
As you can see, the Sigma gives up a little bit longer a zoom, but gains a wider aperture at both ends of the zoom for lower light and has a closer focusing distance. So, if you don't need the extra 10mm of focal length, then I would probably go with the Sigma option, especially given the price drop.
Beyond that, the only additional detail that could be given would be highly dependent on what you want to photograph.