OK I had to make a decision and fwiw, this was the camera that won - the TZ40 (ZS30).
The slight bummer is that it only does full macro at 24mm, but given the lack of an articulated screen, one thing that will intriguing to try out will be remotely controlling the camera via Wi-Fi, via my...