I highly recommend the Fall from Heaven mod!
And it's that which those two mods are based from.

FfH2 had some impact within the gaming industry. And the mod won a 10k 1st prize for best mod at ModDB. The team donated the money to a good cause. Eventually, Kael aka Derek Paxton, designer+ of FfH2 was hired by Stardock to lead the development of a new strategy game.