SQL or NoSQL for user profiles, which one's better? That's the big question, isn't it.

hey ppl im architecting a new platform and hitting a common crossroads user profile data we expect millions of users and profiles will include basic info preferences and potentially some dynamic activity data im weighing sql like postgresql against nosql like mongodb or cassandra sql gives acid and strong consistency which is nice but scaling writes can get tricky nosql offers flexibility and easier scaling but managing consistency and complex queries across different profile structures is a concern what are your experiences when have you leaned towards one over the other for similar user centric data and what trade offs did you find most impactful