My "normal" Canon 10D lens is the 17-40 F/4 EL series. It's a bit big, but excellent. At the time, it was about the only choice in the 17mm range (about 3 years ago). I think it was >$700 at the time.
For macro, I have a Sigma 50mm F/2.8. Can do 1:1, which on the 10D, is proportionally higher. Very compact and light, too. <$300 at the time.
I haven't been following Canon's macros, but when I got mine, their options for anything approaching 1:1 were limited.
edit: just fyi - I have the 75-300mm IS tele. Mechanically, it doesn't feel as smooth as the non-IS lens, but the image stabilization is worth it a bit of compromise. It literally drops your minimum hand hold shutter speed by 2 or 4x (slower). Would have preferred the EL version, but it was (probably still is) a just a tad pricey.