Canon 100mm f/2.8 Macro is the best bet for the money. Sigma 150 or 180 f/3.5 are great for the long distance. Adorama refurbished right now has a Canon 180mm f/3.5 for only a bit more than the Sigma (usually it's a $500 difference). If you get the 180's, the twin light won't fit on it without an adaptor, but I usually use natural light with that anyway. It will fit on the 60mm or 100mm macro's.
Then there's the MP-E 65mm, which does the 1x-5x macro, but that's another beast.
Fun times