Self-hosting apps seem like the way we're going to go in the future. I do like the use or Archive.org to help the end user, and the rest of us at the same time.
One of my daydreams is a common self hosting specification and server that abstracts AWS, Google Cloud and Azure and hosts apps in one click. For example, myflickrr.com/common-host.json can specify Docker images for web and workers, provision them to AWS ElasticBeanStalk, set up scheduled tasks, create a S3 bucket, share a relational DB, set up logs and alarms, provision wildcard emails and captcha with *.mysite.com etc.
I feel like a part of what you want can be attained with yunohost (https://yunohost.org/#/): it's like a "web services distribution" where packages are complete applications.
I really prefer hosting applications on my own, instead of using any third-party service. Sure, the freedom comes at great costs (maintenance, updates,...), but I am willing to spend my time instead of taking the risk for my data and "critical personal infrastructure".
The only downside is, and maybe ever will be, that self hosting is nothing for the casual user.