You are very right, the phone's focus in macro mode struggles and it is mostly on the soft side in close-up shots. I have written about it in detail with sample images as well on my tech-review blog here.
Nexus 6P Macros and Close-ups Performance Review | REASONTOUSE
I believe the best way out...