IMO, I was with you up until recently that the Moon might get bypassed in large, in favor of Asteroids or whatnot.
However I think the ability to work and "stand on something" may show limits to what can be done in zero g, where every torque and push has to be counter-thrusted, whether you're human or robot. And unless we go big on centrifugal force spinning habitats, the long term medical effects of microgravity are beginning to pile up by the month after each new study. 1/6th might be enough to make a difference vs. zero.
Then there's also the issue of shielding from CME's. Digging a hole into the Moon is relatively easy. You can get behind an asteroid, but if you want a permanent inhabited structure in space, you have to shield it and at some point, trucking the shielding to where you want that structure to be, might just not outweigh going where the shielding is instead.
You can also make "spin cities" on planetary bodies that have less than 1 Earth Gravity where the city or settlement is like a large shallow cone with tilted buildings and streets where the "gravity" is a thrust vector combined of both the natural gravity, and the angular momentum from the rotation. Like making a constant bank turn in an airplane. And keep it all shielded underground from radiation...
It's proximity to Earth, reasonably low delta-V for liftoff (as compared to Earth) no atmosphere to force wasteful aerodynamic shapes and mass-fraction penalties onto ships, proximity to the L1-5 Liberation Points, an environment that otherwise has the potential industrial benefits of the vacuum of space, but somewhere for men and machines to walk, stand, roll, crawl etc. might mean the Moon becomes a big hub for manufacturing, processing, and housing humans that don't want to go all the way down the well...
First maxim of real-estate, location, location, location.
Also, there's been LOTS of "useless land" in history that we didn't figure out what it was good for until much later. Or ideas, procedures or industries we won't figure out until we're there.
I definitely agree we don't need to be "moon fixated" just because it's "there" and a superficially logical next step, but we should keep an open mind and go wherever the economics, the energy, and the resources dictate.
