The excellent Atomic Rockets site is designed as a reference for realistic sci-fi, and has a page on MacGuffinite, aka something that makes space exploration economically viable. The long story short is that there's really not all that much that can't be done here on Earth or at least in low orbit.

http://www.projectrho.com/public_html/rocket/macguffinite.ph...