I am just thinking
aloud by scribbling for a moment.
If utopia isn't realistic - and I agree it isn't - than the present halfway status (let's call it RealLife for now) between dystopia and utopia is
hope. Hope we won't fall back to the first and hope we have the strength and imagination to keep striving for the latter. It won't come by itself.
Ora et labora.
I can picture a story about this struggle, the hero fighting RL's inertia, told in a positive narration, maybe even with some healthy dose of self-irony and comic relief, but with a hopeful ending. We will get there, someday! Fine.
If such a story would be set in present day, the setting would be recognizable for many... but it wouldn't be SF. (Unless you give the ending a SF twist.)
Would such a story, set in the future, where RL is already better and more promising as it is today - because we don't want stories about or set in dystopias, right? - still make an appealing story? In this imaginary world people would, up to a point, to our eyes already life in a kind of utopia.
What I am trying to say is, any story needs a conflict, there must be some ugly RL situation, which people can identify with, to start from. Which is opposite of the fun future whose viability this thread is exploring.
The question might be, how realistic do you want the setting to be? If the present day's stories reflects present day's outlook, which is, as indicated above, more grim as it was 3-4 decades ago, than you could argue that writers (willingly or not) tell their stories from the same grim - and realistic? - outlook. Which might lead to the conclusion that any picture of fun futures and frolicking protagonists is therefor not and our need for it is escapism. Which, speaking for myself, I will not deny. But any stories told from such a perspective tends inho to drift towards comedies and fairy tales.
I am rambling, something I had resolved not to do anymore (at least not publicly
). Worse, I might be totally wrong.
All in all, I want realistic stories, not fairy tales. That's why I love The Expanse as TV-series. A vision of the future in 200 years that's believable. That future is for some an utopia, for many a dystopia, distrust and conflicting interests are all around. I have no problem with such realistic tales, as long as the tone of the narration remains optimistic and there is room for humor and different perspectives.
That somehow sums it up for me. I don't necessarily need stories about fun or ideal futures. I want stories with a hopeful outlook.
Thus ends my thinking. My apologies for it being aloud.