I didn't read this whole thread but if I am remembering right, much of the hard sci-fi I have read is pretty good and usually paints the smart scientists as the heros. Off the top of my head David Brin's Earth, Gregory Benford's Artifact, Ben Bova's Grand Tour stuff, etc.
If Kim Stanley Robinson's Mars trilogy didn't get us the inspiration to colonize Mars, I don't know what will
