Hello all.
I'm looking for opinions and advice on finding a lens to suit my needs.


I'm currently using a Canon 40D and have a Canon EF-S 60mm f2.8 Macro, and a Sigma 17-70mm.



I primarly use my lenses for indoor & outdoor shots of miniatures, diorama set-ups as well as professional scale models (my husband is a professional model and prop maker).
I love the crisp, sharpness that I get from the Canon 60mm Macro but am finding it very limited when I have only a small space to work in--it can make getting some of the full images difficult to say the least.



I'd bought the Sigma in an attempt to have something that would allow me a larger range, but I don't find it to be particularly sharp, and I guess I may be spoiled by the 60.
Can anyone recommend a zoom (I'm thinking somewhere between 25-200max) that is reasonably priced (I'm not a pro & can't afford L glass), and sharp?
Any help is appreciated!