CAD is just a generic term for a type of software. That said, yes, CAD is very good for making maps as that is the tool of most modern cartographers that aren't going for an artistic look. Applications such as AutoCAD, MicroStation, and even Campaign Cartographer are all CAD applications. The way they work is pretty much the same across the board. (I was a CAD draftsman for several years right after college - I used AutoCAD and MicroStation) So if you learn one of the CAD applications you'll have an easy time with any of them once you learn the commands.

This leads me to Campaign Cartographer 3 which you'll see many fine examples of maps made by it on this site. If you can afford it, it is much cheaper than the "big CAD" apps, you may want to consider going that route, but ultimately it depends on what you want your end result to look like. Take a look around and see which of the different apps produce the most maps that you like. That should help you decide.