Call me a cynic, but when I see people wax poetical, I tend to suspect it's because they want for cold, hard facts.
I see very few tangible benefits from the space shuttle and the ISS. You say "they are opening doors." Doors to what? Low earth orbit? It's a very expensive trick, a dangerous one at that, and one that yields zero additional scientific knowledge. I'm hardly anti-space, but manned space flight makes no sense from any perspective.