Terragen makes some really realistic terrain with water and a godly sky, but the problem is that it provides no other features that are really good. Well, the height maps can be imported into max or lightwave, but really, it's kind of tricky to get anything done with them.
"Stephen Wolfram is the creator of Mathematica and is widely regarded as the most important innovator in scientific and technical computing today." - Stephen Wolfram