for the tiny stuff, shooting at 1:1 (stuff the size of your camera's sensor) or greater, you will want the canon 100mm macro lens (which does 1:1 max i think) and add a diopter or even a teleconverter to shoot small stuff.
Shooting at these magnifications is increadibly difficult. Focusing, steadying the camera, lighting and limited depth of field are all major challenges with super macro. A focusing light is almost a necessity, as is a bare sandy patch to rest yourself on in order to keep the camera steady.
There is a pinned topic "going beyond 1:1", or something like that, in the Digital SLRs/Housings forum. check it out. Cheers,
Chris