I use the the Canon 100mm F2.8 IS L and the image quality is stunning. The thing to note about any macro lens is they have to be sharp, any in-perfections will stand out a mile due the to magnification.
Bear in mind, as others have said that you will really need a flash when working at higher...