Many decision trees I've seen when NoSQL purpose-built were becoming popular are obsolete now that the main SQL databases have structures, APIs and optimisations for non-relational models: JSONB, Text Search, Timeseries, Documents... Today, the differentiator on architecture goals: converged database vs. multiple services