The reality is that if you go to any family BBQ and start going on about the importance of self-hosting, I - someone that’s been working with computers my whole life - am going to roll my eyes and not be all that interested in the conversation, let alone anyone else there (chances are they don’t want to talk about computers at all).
The reality is that these open-source / self-hosted solutions are, the vast majority of the time, harder to use and maintain. There are few things that sound less appealing to me than dealing with the realities of helping my family and friends with using any of that stuff.
This is all just some nerd’s out of touch pipe dream.