Other than scientific inquiry or barring some specific mineral wealth, I agree. Everything we need can be found floating in space except for a gravity well to live in. If we're capable of living in space, why deal with an atmosphere that does nothing but add to the energy cost of leaving it?

The future entirely depends on just what we discover about human adaptation to microgravity, likely from experimentation on the Moon. If we can remain healthy and especially reproduce in fractional gravity, other planets have much less appeal than the moons and asteroids that don't require a huge energy expenditure to reach.