I'm looking for books like the title - a realistic but hopeful depiction of the future. Mostly interested in near future, building after the revolution type stuff, but I'd be open to more outright utopian sci-fi as long as the worldbuilding was interesting.
Serial web fiction addendum:
Unjust Depths is a fantastic trans lesbian communist undersea gundam story.
What Little Remains of Terpsichore Ironheart is the story of an elf several hundred years after humans did a campaign of genocidal colonialism to elves on a quest to burn it all down and build a better future from the ashes.
The John Brown Isekai is exactly what it says on the tin. John Brown gets isekai'd straight from his historical execution and starts a slave rebellion in isekai world.
Otherworldly Anarchist is about a genuine street fighting anarchist in a world of magic, monarchy, and slavery.