Realistically, the best solution is hosted and managed versions of FOSS apps where the private data is encrypted. Most people just don’t want to manage a server, and this solution would provide funding to FOSS projects while also increasing data sovereignty for non-self hosters.
As much as we all might want it to, self hosting will never be mainstream.