living in space

We seem to be headed back to the Moon, and if Elon Musk can take time away from Twitter, perhaps Mars. What might living in those places be like?