I agree with you that the AI 2040 vision of utopia is weak, but even a version which was more socially exciting strikes me as far below what I'd expect for "incredible post-scarcity realm of wonders".
Consider programming. I like writing computer programs enough to sometimes do it for fun, even when I don't expect to materially gain from the thing I'm building, and even considering all the potential alternatives (including social, physical, artistic...). This is not a hobby that I could have imagined having 150 years ago! Someone from the 1850s could live out their perfect dream utopia: every need cared for, every desire fulfilled, every fantasy enacted, and even if they're having a great time, there would still be this particular pleasure, which I am regularly blessed with, that they'll never know.
What I take from this is that we probably aren't done discovering new varieties of experience, nor do we know about everything worth doing. If in 50 years I'm still doing all the things I do today, just at a higher quality, I would be disappointed, because it would mean that despite all the talk of progress the human condition had stayed basically the same. I want my future self to know unfathomable vistas of beauty and wonder so vast that my present-day self can't even visualize them! This makes for a worse story - how can you build a compelling narrative out of something literally unimaginable? - but it would be much better, IMO, than any concrete positive vision I've seen put forward.