I've been carrying a Sony TX100V in my work bag for I suppose 11 years now. I'm on my second one. It has staggeringly good macro capabilities. I've had two 8x10 prints done this year and they're amazing.

It's a 2011 model and AFAIK the latest in the line. You have to go much bigger to get better quality. I'd buy an updated model in a heartbeat.

https://www.dpreview.com/products/sony/compacts/sony_dsctx10...