As a Space Nerd™ here are my two cents:

• Satellites: Very worth it. Loads of benefits.
• Space telescopes, probes and robotic missions: Costly, but the science return is great.
• Human travel: Not great cost/benefit, but great for national morale. Crewed low Earth orbit laboratories like the International Space Station also allow for faster and more advanced experimentation than an automated platform.