The best set of terrain used to be Hobbes expanded terrain set, but unfortunately he stopped supporting it once it got integrated into his Area51 full mod. hellrazor also did some great work on maps for alien bases and terrors, I think, amongst others. Unfortunately, there isn't "the one globe/map/texture/terrain mod" but I agree that it would be a worthy goal to pursue.