As I understand it (I do not know that much about it), Cosmos is a multitool with features to fit many, many use cases.

You must be diligent to develop your application to use it efficiently from both a cost and performance/latency perspective.

Those that put in the work may not love it, but they are very successful at operating at scale. Massive, insane scale.