diaspora probably was the most popular failed project which tried to achieve this. It did not really fail per se, but it's pretty clear by now that it will never reach impactful adoption.