I've got a couple of connections to NASA. We do a ton of work for contractors since we're right in the middle of "NASA" central here, and my dad worked for them (through a govt. contractor, where most of the work is designed) for 40 years, engineering pieces for not only the Apollo missions and Space Shuttle, but everything in between.
The real benefit of the program reaches far beyond what you see visually. Not only does a lot of the technology eventually trickle down to everyday use (you should hear about the materials now in use by Nasa and other govt. agencies, it makes titanium and kevlar look prehistoric, or the massive computer systems the size of a grain of sand, or the technology for communications that do not use radio wave the way cellular does, and on and on.) but most are funded by the government for military and / or space use.
The real benefit though is the inspiration it brings in sciences. We are now sadly lacking in the production of scientists and engineers, ranking far below China and Japan. Without the ability to keep up with technology, we're pretty much screwed. Until recently, most of China's elite came to the US, but this coming to an end. I cannot stress enough the problem that this has become.
The space race of the '60's in particular created an enormous interest in all types of science, and the US benefited in areas most cannot imagine. During the past year we've had the good fortune to interview pretty much a who's-who of the area, and a to a man, they almost all said it was watching the Apollo missions that got them into it in the first place.
One even carried Werner Von Braun up the courthouse steps here downtown when he was a teenager. That man now is the world's leader in biotechnology, and either him or one of his companies created much of the DNA techology used worldwide. (a current project by one of his protoges, determining everything wrong with a human body by one drop of blood)
This is just one example, but there are thousands of others, and none would have happened if it weren't for the Apollo missions. Many people out there think that investing in space is a waste of money, but really, it's a waste not too. I get a little passionate about this, as I wish everyone could see the very real benefits that come from a high profile mission such as the one proposed for Mars.
With the drastic cuts in Nasa's budget in the early '90's by the Clinton administration, many of the companies had to survive by changing what they do, and for whom. Imagine what could have come about had the governement continued to explore space and other advanced technologies?