I could envision pre-configured vps images maintained in the open by volunteers to make it more practical. They could have unattended-upgrades configured for major patching and the community could help migrate between major LTS releases.

It isn't ideal but it might be doable at least for some projects. Maybe devops people want new ways to contribute to open source too!