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.
Definitely check out Everything for everyone: an oral history of the New York Commune, 2052–2072 by M. E. O’Brien and Eman Abdelhadi.