I'm talking about dedicated macro lenses or lenses with macro settings. where my 80-300 @ 250mm going through the stops, I may have 3-6 feet of DOF variation, when I set the thing to Macro, the DOF variations become fractions of an inch if not millimeters.I mentioned earlier that I think it could use a little more dof, however, the big issue is sharpness. If you bump up the sharpness in post-processing, the dof can be better judged (and it will look better)... possibly enough to give a good sense of depth, without the flatness that come from too much dof. There will be a limit to how much you can sharpen this image before artifacts take noticeable effect, but the photo does have headroom for tinkering.
MarkM - DOF is determined by f-stop and distance to subject. The macro mode that some cameras have does not in and of itself have any effect on DOF. The macro mode is simply used to tell the camera to focus at close range.