Manual Macro (kinda fuzzy, but much more zoom)

With a magnifying glass (cheap jeweler's loupe for me) supplementing your camera, you can get in really close to what you're photographing. It's not a crisp image (you're holding the magnifying glass manually, and it's hardly as precise an assembly as a camera lens), but it's much closer than macro-mode, and it's sufficient for a fair amount of detail.
I use it extensively when writing up instructions to provide some visual context, without the need for fine art photography quality.

Crane, Tiny
(for scale, that's a AA battery)
Click image to see it at 600x450 (which is still less than 29% of original image size)
No flash, on a point-and-shoot (5.1mpx)


And for comparison, a different item with similar composition on a different camera:
Stars, tiny.
This shot was taken with flash, on a DSLR (~10mpx?) It's clearer, I guess, but it's a royal pain to edit/crop.