If I had a database with push based replication instead of pull based, then one of the apps on my todo list would be done by now.

There are certain application types where I think it makes sense to self host the admin interface and cloud host the rest. None of or only a fraction of the write traffic is ever exposed to external access, and if done right the app can work fine with two nines of uptime on the admin services. Which puts it into the realm of running it out of your home office and having it sync to the cloud.