I know I have mentioned it but to add to the list of programs that you should look at there is also L3DT, WorldMachine, and Global Mapper. We have already mentioned Fractal Terrains, Bryce, Vue, Terragen in many posts. Theres probably others too but they're not leaping into my head right now.