The Coolpix is only my "play thing" for quick snaps when I'm lazy!
But seriously, I don't think this CP is a best unit for macro-work as you have to judge the image composition and focus via the LCD screen only... no other way to view the image while shooting! Also it is not very good for tracking moving subjects, especially at such a close distance from the lens! The other problem is no DOF control so have to accept what ever the on-board CPU decides! Maybe when I get the CP995 which seems to be more versatile.
My normal kit for shooting macro are actually the Nikon SLRs with the associated accessories... ;p