Simply put the MP-E 65 is the best high magnification field lens made. You can go from 1:1 to 5:1 with several twists of the helicoid. The minimum magnification of 1:1 does limit whole subject size you can capture to the size of your camera sensor.
As others have noted there is a steep curve. If you want increased DoF, i.e. shoot f8 or smaller, a diffused flash is a must. You won't find many off the shelf solutions that produce consistent results. DIY solutions, speed light/homemade softbox diffuser produce, DIY diffuser heads for MT-24EX, etc. produce the best results. Shooting handheld at high magnification (2X plus) is doable but requires practice. Working distance at 1:1 is ~4 inches. At 5:1 working distance is ~1 inch.
Overall an excellent lens if you want magnifications greater than 1:1. If you're not interested in high magnification macro you would be better served with a quality 100mm macro - good working distance and less weight than a 180mm