There isn’t one universal “best,” but for low-latency user profile storage across multiple regions, the top choices are usually:

Best overall for global, low-latency profiles

Google Cloud Spanner

Why it’s strong:

• Strong consistency across regions
• Global replication built in
• Excellent for user profile data that needs correctness and low latency
• SQL model, which is often easier than pure NoSQL

Tradeoff:

• Not a NoSQL database
• Can be expensive
• Best if you’re already on GCP or need strict consistency

---

Best pure NoSQL option

Amazon DynamoDB Global Tables

Why it’s strong:

• Fully managed NoSQL
• Multi-region active-active replication
• Very low read/write latency
• Great for user profiles, sessions, feature flags, and similar access patterns
• Scales extremely well

Tradeoff:

• Eventual consistency across regions
• Data modeling requires careful access-pattern design
• Secondary indexes and complex queries are limited compared to relational systems

---

Good alternative if you want Cassandra-style architecture

Apache Cassandra / Amazon Keyspaces

Why it’s strong:

• Multi-region capable
• High write throughput
• Good for large-scale distributed profile stores

Tradeoff:

• Operational complexity if self-managed
• Modeling/query constraints
• Latency and consistency behavior require careful tuning

---

If you want global distribution with simpler app-side consistency

MongoDB Atlas Global Clusters

Why it’s strong:

• Flexible document model
• Good fit for user profile documents
• Global distribution with region-aware writes/reads

Tradeoff:

• Multi-region architecture is more nuanced
• Not as universally low-latency/straightforward as DynamoDB for simple key-value profile access

---

Practical recommendation

If you specifically want distributed NoSQL + very low latency + multiple regions, I’d usually recommend:

• DynamoDB Global Tables if you want a managed NoSQL system and your access pattern is mostly key-based profile reads/writes.
• MongoDB Atlas Global Clusters if profiles are more document-like and you need more flexible queries.
• Cassandra/Keyspaces if you need massive scale and are comfortable with data modeling constraints.

Simple rule of thumb

• Key-value profile lookup by user ID: DynamoDB Global Tables
• Complex profile document + flexible queries: MongoDB Atlas
• Highest consistency across regions: consider Spanner even though it’s not NoSQL

If you tell me:

1. your cloud provider,
2. whether you need strong consistency,
3. read/write ratio,
4. and the kinds of profile queries you run,

I can recommend a specific database more precisely.