The Sony HX400V I have takes remarkable macro pictures when pared up with a macro filter. The small depth of field gets frustrating though for insect pictures. So, I recently started using photo shop to stack images.
The workflow is simple, take a burst of photos while slowly moving the camera closer and farther from the subject. It produces a bunch of photos like these:
On their own none of these are particularly impressive, but the batch of photos stack together well into the following photo:
This should work much better when my Sony a6300 comes in the mail, since it has a much larger buffer and with a macro lens better sharpness. Still, the amount photos are improved is quite impressive.