It makes less sense to categorize them as NoSQL. It implicitly means 'eventual consistency' and 'no relations' depending on who you ask. Some of the 'NoSQL' databases offer some consistency features, other distributed scalable databases nowadays provide relations and strong consistency models (FaunaDB / FoundationDB / CockroachDB / Spanner) although we would be tempted to categorize thos as 'NoSQL', or 'NewSQL' (but not all of those offer SQL), these terms imho don't really make sense anymore. Some of the older 'NoSQL' databases even start to add consistency features or some form of relations. In other words, the difference between NoSQL and SQL is fading. How good a database can support certain features at scale is what matters, and that depends on the algorithms behind the database (there are many approaches). Imo, look at the algorithms not at the buzzwords such as 'NoSQL'.
There is still a need for databases that are built for scalability (and there is a growing need for those that work well together with serverless), but in many cases, there is no need to abandon consistency since new algorithms make it possible to have consistency, relations and low latency.