And there's the Earth-study end of things, including a great deal learned about the Sun and its effect on life right here at home, etc.
And how long did Pioneer 10 keep sending home valuable tidbits of data on the composition of the solar system? Thirty years? It's entering interstellar space, and NASA made it happen!
I think I got my money's worth on those missions... but I'm not like most people; I get pretty excited about stuff like that.

But yes, as far as manned missions go, the showboating and poll- appeasing has to stop, and all the world's space agencies (and the emerging private groups) should focus on setting stepping-stones firmly in place.
It's definitely just a daydream at this point, the idea of humans occupying space and other planets, but the dreamers are always the ones who get such ventures started: Tsiolkovsky, Goddard, Von Braun, etc.