Well, you could try to raise the challenge. Eg do it on a limited budget, or establish a permanent base, etc.

However I agree that manned space flight is a giant money pit with not much to show for. It should come out of our entertainment budget, not eat into our science budget.

If you want to do science in space, go unmanned.