Rendezvous with Rama by Arthur C. Clarke. A modern classic of science fiction, it really does give you sense of mystery and awe.