Too many lenses...it's gotten out of hand! Shooting with 1D series bodies.

For a general purpose zoom, the 24-70 f/2.8L and 24-105 f/4L IS are both excellent choices. My 24-70 is sharper than my 24-105, which is apparently not usually the case. The one-stop advantage in speed is nice if the subject is moving at all; if not, I prefer the 24-105 because of the 3-stop IS, lighter weight, and zoom design. I also have the 17-40 f/4L and 70-200 f/2.8 L IS, if you're interested in an opinion on either of those. Another post suggested you'd be using this on a 1.6x crop body; the 70-200 is extremely long, even at the short end, on a 1.6x body. A good comparison site for Canon lenses is the-digital-picture dot com; they have lots of crop samples for the various lenses at different apertures on different bodies but with the same framing; just be aware that there can be a significant amount of variance between what they show and what you might get, as the bodies and lenses all have differing calibrations in my experience.

I've generally moved toward shooting primes whenever possible, but I don't have any macro lenses, so no help for you there; I think the 24-105 has a slightly higher magnification than the 24-70, but you can check online whether I'm right or wrong. I've got a bunch of ridiculously priced primes if you wanted an opinion there. A great value, IMHO, is the 50 f/1.4 USM.

As a general aside, it's always a good idea to test drive lenses for a day or two to see if you like them. The weight/handling, FOV, depth-of-field, image quality, etc., are things you can't really determine unless you actually have one in hand. There's lots of places that do rent and will deduct the price from any lens purchase. In addition, many B&M shops will match (or come close to matching) the B&Hs of the world if you ask; if cost is a really big concern, I highly recommend keh dot com as a reputable buyer/seller of used gear; alternatively, the buy/sell forum at fredmiranda dot com can be an awesome source of used gear, with all the requisite precautions taken, of course.