The GAO in the past has said in the long run NASA has stimulated more tax revenue than the NASA budget.
The  problem is can humans live off planet in any significant numbers. I doubt it.
What do you do about sex?
		
		
	 
Abstinence my dear fellow. Abstinence.
		
 
		
	 
Why would they need abstinence? I see no problem with sex in outer space or on Mars or the moon.
		
 
		
	 
You have not socialized much.
Starting at puberty the sex drive is always there until we die, with ensuing conflicts.
If you gave 10 guys and 9 girls and one guy is left out of sex what harpoons socially?
What happens if a guy becomes abusive and aggressive?
And then there is religion. Is somebody excluded for being an Evangelical who wants to spread the gospels around the solar system?
Who wants to spend two years in a confined space being preached to?
Do you exclude a conservative Muslim who opposes fornication?
If we go to the Moon and Mars we inevitably bring all o0ur social issues.
		
 
		
	 

 You're getting a little out of hand dude. I remember as a kid in the early '70's we had an astronaut come to our elementary school. I wish I could remember who it was, but I believe he had already been in space, or was in training to go soon. Anyway, there was a Q & A session at the end, and someone asked what the biggest problem was being confined in a small space capsule with others. He said, the B.O. We all laughed our ass off. Is B.O. still a thing up in space in 2024?! 

 I remember one girl raised her hand, and her question was, "Are you married?!" 
 
		 
		
	 
I am being realistic. The technical term is human factors.
	
	
		
		
			Human factors (also referred to as human factors psychology and human factors engineering) is an applied field of study that examines human abilities, limitations, behaviors, and processes in order to inform human-centered designs (those which include the human perspective throughout the design process).
		
		
	 
As a kid in grade school launches were a big deal, TVs were brought into the classrooms.
I had a pencil sharpener shaped like a Mercury capsule.
When the first Moon landing occurred the word stopped for a while.
AS an engineer I kept  a model of Yeager's X1 on my desk for inspiration. He named it Glamorous Glynis after his wife.
The space program was inspirational in my generation.
But that is not what I am taking about.
Human factors is as much a design issue as is propulsion and life support.. Put a small group of people in a small environmental  space for a year or longer and what happens?
Put a colony of a few hundred people on Mars for a few years and what happens stoically and psychologically?
Even in small groups power factions can and do evolve.  Human social politics.
Do you allow drugs and alcohol? Religion? Gays and straights?
What happens if someone loses control and gets violent? I would think the pressure of lvng in a mrtas cony wold be enormous. There is no escape, no place to get away and take a vacation.
On Mars there will be the same problems we have here.