Honestly, there are things I would like to see the moon used for. Practice landing and learning to switch from feet to meters is one (so we don't crash stuff on other worlds anymore). Sending some sort of rovers to head towards the dark side and watch for asteroid impacts (how often, types of asteroids, materials, rare elements etc, that could advance a space program). Otherwise I agree, no goal, no real motivation to go.
I think the science with unmanned vehicles, may lead to their use to build somewhere for us to go to, first.