I always thought the "but look at all the science we got out of it" line was rationalization. The Moon race happened because it was a contest. The reason I would buy for either Moon or Mars colonies would be access to resources in the belt.