> but don't need clustering or failover strategies.
Even for those cases where you do need it, there are emerging options. You can handle replication 100% in business logic (something I personally enjoy), or you can use a path like dqlite to replicate the physical WAL log.
I get the impression that it's used exactly as it should be, in systems that need a database but don't need clustering or failover strategies.