We use the Canvec WMS server on a regular basis for localized mapping, and love it. Simple to use, easy to access, free, well rendered and consistent (well free if you ignore the fact that it is supported by the taxpayer).
It works well in ArcGIS but I am having difficulties connecting to the data using the AutoCAD Map 2001 3D FDO.