I do not fault the r/selfhosted masochists, no kink shaming here, but recognize outliers vs the mean. Go talk to average folks for 15-60 minutes on the street about what social (video, communities, threads/twitter/x/whatever, etc) means to them, this will help calibrate perspective. This is just product and user research. Find out what people want and build it, don't build what you think they want. Product market fit is not just for startups.