So, I was thinking that the hyperfocal setting, or the DOF, might be somehow applicable to macros.
..... john
Hyperfocal is (quoting wikipedia)
a distance beyond which all objects can be brought into an "acceptable" focus. So it's relevant when you want to capture relatively near stuff out to infinity (think landscape or maybe a street scene), but not for normal macro shooting where everything is much closer than infinity.
DOF is a product of aperture and zoom. The DOF calculator will show you near / far limits, but you are probably better off evaluating these from the live view or test shots. The specific distances in the DOF calculator may or may not be accurate, and in any case, you probably aren't measuring the distances.
With CHDK, you can often get slightly more DOF by overriding the aperture beyond the normal Canon value, i.e. f/11 instead of f/8 at wide angle, or f/16 zoomed. This may hurt image quality a bit overall due to diffraction. It will also longer exposure, and you will need to set all the exposure parameters manually because the Canon firmware is not aware of the override value.
If you want even more DOF for close up shots, you probably have to resort to
focus stacking