To your last sentence, exactly! The Russians just sent up an unmanned re-supply vehicle, which successfully docked with the International Space Station. I don't know what ultimately happens to the vehicle, but it sure is a lot simpler than the Shuttle.
I am not opposed entirely to manned space missions, but since a human life, especially from among the best and brightest, is sacred, we should be a bit more selective in what we send them up for. As for the ISS, perhaps it would have been more practical to develop a smaller vehicle to transport humans to and from it. The vehicles that were/are initially used to transport parts of the ISS should have been designed to become a part of the ISS. That's what I call efficiency.
I don't want to take my time to do the analysis since others are being paid to do just that. But I strongly suspect that the probablity of bringing a human being back from space is inversely proportional to the size of the vehicle. The Shuttle is just too damned big to be safe.
As for the last mission of Columbia, I believe that the "experiments" that were carried out were not worth the dollars, much less the lives of the seven astronauts. Yes, you may say that we have to transport people back and forth between earth and the ISS, now that we have the ISS, but how in the hell do you justify a half billion dollars to study spiders?
And before you start flaming, let me say that just before retiring from an aerospace company I was involved in a contract with the Naval Research Lab to conduct a "space experiment" on the Shuttle. It involved superconductivity. There was absolutely no way that the device would act differently in space than it did in our laboratory, but NRL spent hundreds of thousands of dollars to shoot it up into space - and they confirmed my analysis. And the astronauts received acclaim. But I feel that they were risking their lives for nothing, unless they were simply satisfied with just being in space.