Oh sure, if your work or career took you there, it might be a great experience--for a while. But it really would be the equivalent of an underwater habitat, a trip to the ISS, or a tour in an Antarctic base. Those places don't seem to get too many volunteers for long-term residency--and the commuting costs are much more reasonable.

The moon is a blasted piece of rock and slag, unless you're a scientist studying it, there is really nothing there. Business opportunity? That's a Heinlein fantasy, even if you found something of value it would cost too much to haul it back. And sure, the moon is a vast place, with the surface area of Africa, but you just can't go out and stroll around and see the sights without a REALLY good reason. Just going out the airlock to check the progress of your experiment or to pick up a few moon rocks would probably require an hour to prep your suit--not to mention the environment is deadly. Every EVA would be strictly controlled and require a support staff and considerable technical assets. Not exactly an environment conducive to freedom, entrepreneurism and low-g sports.

Life there would be a lot of bad food, smelly, overcrowded quarters, constant safety drills and an occasional terrifying emergency. It would be like living in a WWI-era submarine. And once you started getting old, they'd ship you back home (or shove you naked out the airlock, after first harvesting all the titanium in your dental work). They can only afford healthy, young productive people there. Too resource-expensive for tourists, retirees and kids.

On the plus side, your fellow colonists would probably be pretty neat people, highly intelligent, highly motivated, real A-type personalities. Lots of young, fit, over-educated horny people! But the support staff, the pipefitters and programmers, electricians and hydroponics specialists, dental hygienists and A/C techs would probably be a surly lot always forming unions and threatening strikes. They would not get along with the lofty scientific and administrative staff. So that probably means a big security goon squad to maintain order and enforce the endless safety and conservation regulations.

Yeah, people flocked to colonies on Earth a few hundred years ago, but that was no picnic either. Slaves, sharecroppers, indentured servants, military deserters, the no-pot-to-piss-in poor, freebooters, soldiers-of-fortune, religious fanatics, pirates, convicts, refugees, second sons, ax murderers and sex perverts...they weren't all fucking pious Pilgrims looking for their freedom in a new world, mostly they were desperate people out of options and those eager to victimize them. It all makes for romantic reading and patriotic nostalgia, but for most of them it was the pits.

Hey, I read science fiction when I was a kid, I probably would have jumped at the chance to sign up if I were young and stupid. You know, living under the shadow of Saturn's rings, mining the Belt, the ice moons of Neptune, the Sands of Mars. Yeah, I'll do my graduate work on the moon, or my Peace Corps tour, but I want a return ticket and a one year contract, guaranfuckingteed. I'm a grown-up now. I know better.