The only way I can see the Moon being of value is as a launching point for bigger missions to Mars or other solar systems. Someday, this planet and solar system will die. I would hope that generations beyond us will have another place to go. I think I read somewhere long ago that producing certain materials in low gravity or no gravity environments can make them stronger. That would be interesting.
Then again, maybe we should all move to the Moon and Nuke this place.