If you're simply talking best then I'm still in the Adobe camp. Sure, forking over several hundred dollars for a powerful image editing suite is scary - but the results can be amazing. Next down the line I'd go with the cheaper alternatives, GIMP and all the others. Campaign Cartographer, if I were going to go with a dedicated mapper, would be the way to go I think. Mostly because I'm pretty sure it's going to be around next year and might eventually come out with new, easier versions and that's something you just can't stress enough with software that you're going to want to invest some large amount of effort into learning. Plus CC seems to produce usable maps even if you didn't go to art school, which I suppose is a plus for a lot of folks.