I'm thinking primarily of sites like YouTube here. Sure, we all sacrificed the ability to customize the way that we serve videos to others, or the freedom of not being on a platform that someone else owns, but some of the best people on the site are people that aren't technically focused at all. These people would not have been able to publish anything if the barrier for entry wasn't lowered.
And on the opposite side, if you look at places trying to bring back the small/old web, you run into the issue that generally everyone there has the same interest of programming or technology, since it's borderline essential to get into these places in the first place. It's sometimes surprising what kind of people you find on there, but most of the time it's just a bunch of programmers. The freedom of the old web was brought back at the cost of the diversity of people that populated it.