Red Mars by Kim Stanley Robinson, followed by Blue Mars and Green Mars. These to me are the only ones not mentioned already and are set in an inspiring way that celebrates humanity. Also the Rama Series by Clarke and Lee starting with the second in the series "Rama II".