Would the iPhone 15 with Macro lens work?
The best results I've had with small things are using the super zoom telephoto lenses like on samsung s22. I haven't seen a smartphone macro lens that takes decent photos of things yet (unless the subject is perfectly still). Perhaps the latest gen has found a way but in smartphone land you're mostly relying on software post processing since they capture so little light.