I fully agree with most people on the planet not being interested in discussing anything with strangers on the Internet, and when it comes to Nostr, I usually tell people that I'm much more excited about the Other Stuff than I am about the Twitter use case. Things like Electrum co-signing messages now being much more reliable with the Nostr plugin would be one such example.
I'm not sure you've seen it, but I'm currently working on another use case that does involve people posting public content, and where they do like posting it in a public square, and they currently post virtually all of it to a handful of proprietary silos. The content is photos and reviews for physical places.
I haven't opened PRs for the two NIPs (one for photos and one for reviews) yet, because my app wasn't and probably isn't quite ready for sending a lot of people there as of now. However, I do have the photos implemented, and since last week it's now also possible to zap photos and discover activity from both followed pubkeys as well as other users.
Here's an example of a place with user content coming from Nostr/Blossom:
And discovery is currently here (but also needs to be done directly on the map):
Reviews are more difficult to get right, but I'm pretty excited about those already. And the main challenge, of course, is that we can't have dickbutts showing up when looking at photos of a restaurant you're interested in (which I already solved on the app side, but I'm not pulling in auto-moderated content from elsewhere to the trusted default relay yet).
The idea is that we can have a free market around this content, because it's owned by the actual user, but anyone is able to integrate it in their apps or hosted services.
The draft NIPs are available here for now: 
Marco
Unhosted maps app that respects your privacy and choices.
Marco
Unhosted maps app that respects your privacy and choices.
Gitea
marco
Unhosted maps app