You can get away with a close up filter on the 70-200mm for macro, but you cannot shoot it at 200mm + close to min focal distance, as it will be extremely soft. However, around 135mm + close up + (optional) cropping can get you very good result. The lens is very sharp, and bokeh is stellar. But true macro lens is always the way to go...the tamron is yummy.

That is true for consumer range lenses, or super zoom lenses. Most pro lenses is very sharp across the whole focal length. i.e. tokina 50-135mm, sigma 50-150mm, nikkor 80-200mm, nikkor 70-200mm, and etc.

Lenses like 18-200mm, 80-400mm, and etc...obviously gonna suck at long focal length.