I use Firestore. I think your analysis is spot on. It is great for OLTP workloads. For query/analysis, you'll need to replicate to another database.

another area where it truly shines is zero downtime for schema updates.