Photomacrography, when performed between 5:1 and 10:1 (upwards 10:1, we are in the photomicrography domain, which is even more specialized), is difficult: depth of field is inversely proportional to enlargement and of course sharpness decreases when you close the diaphragm. It is important to note that usual macro lenses (designed for enlargement less or equal to 1:1) are generally not sharp at all when you use them beyond 5:1.
This is why the lenses that are sharp beyond 5:1 are rare and expensive.
Under 5:1, some enlarging lenses are useful. I own a Schneider Componon 28mm F/4, it is very interesting below 5:1 (it is sharper than a Canon MP-E 65mm and, as mine has 15 blades, the bokeh is smooth). You can use it up to 8:1 but sharpness will not be "razor blade".
From 5:1 to 10:1, the best solution is to use special macro lenses (e.g. Leitz photar, Leitz milar, Leitz summar, Olympus zuiko 20mm, Minolta micro rokkor 12.5mm) or microscope lenses (5X or 10X ULWD or ELWD or SLWD APO lenses are better). Please note that there are 2 kinds of microscope lenses: finite and infinite. You can directly use a finite lens if your bellows length is OK, but you cannot directly mount an infinite microscope lens on a bellows : you must use a focusing lens between the microscope lens and the camera. This is a bit technical, sorry.
Here is a very interesting site:
The Macrolens Collection Database