story
Automation is good for rote tasks. People are good at improvising.
During the mission to correct Hubble's lens problem, the supplied tools and procedure failed. The mission specialist utilized scissors and a plastic cover from a log book to correct the problem.
Without that improvisation, the mission to fix Hubble's lens would have been a loss.
What we gain from having people in space depends on what you want to _do_ in space.
If it's all just drones mapping planets and space telescopes then investing in automation makes sense.
If it's manufacturing, settlement, getting some of our eggs out of this basket, then we need people out there, learning how to live off-planet.
The expense in either case, might possibly be the same.
Automation isn't cheap, missions that have to be redone because the automation fails are costly.