I tried to get my head around this too and wrote this a while ago: lemmy.world/post/34986579 – I called it localhosting, and it’s about some ideas that could bring more people into the boat.

I haven’t made much progress unfortunately, but I do believe that selfhosting needs to become more accessible for non techies. It’s a pity how many great open-source selfhostable alternatives are out there, and how little people can actually install and maintain them. This gap is wild to me.