Maybe we are too much influenced by science-fiction and our expectations are based on it.
Let's see.....Imagine we had the 15:00 shuttle to take to Space Station V, with its artificial gravity. From there, there is a Moon Shuttle to Copernicus and another one to L1 (Earth-Sun); we could choose between the monotonous, soft hilled, one color cratered Moon or that outpost at L1, with its views towards the Sun, the Earth, the heavens and all the surrounding telescopes that pour their data and that only computers can follow.
I think a manned trip away from LEO has only a short term excitment about it.
However, if we let things go the way they seem to go now, we might not ever return back there, but we will know more (through robots, AI, virtual reality, waldos) than had we been there physically.

Raoul