I haven't used SqliteCloud so I can't vouch for them but they make a pretty good case for their technology: https://blog.sqlitecloud.io/how-and-why-we-brought-sqlite-to...
Pub/Sub is, I believe, a rare functionality with hosted sql databases so if you need that, SqliteCloud is one of few places to get it.
They claim they have a unique feature: ability to sync the database to mobile device with CRDT. So you can have a hosted database updated from your backend and have it synced for fast offline access in a mobile app. That, I believe, is something no one else offers.
Weblite is also unique to their platform https://docs.sqlitecloud.io/docs/introduction/weblite
And in general, if you're familiar with SQLite, having option to have it hosted by SqliteCloud is better than using e.g. hosted Postgres and having to learn Postgres