We have crossed into Canada many times with a CCL and never experienced any inspection, enhanced or otherwise. One time the line was long enough that an agent went down the line recording license plates. When we finally got to the entrance, the first question asked was if I had a CCL. When I answered "yes", the second question was whether I had a gun with me to which I answered "no, that I knew the Canadian laws and had left them at home". He asked a few more usual questions about destination, etc. and we were on our way.
Had I answered "no" to the first question, I am sure we would have spent a good while having them go through the coach thoroughly in an enhanced inspection since they knew by running our license tags that I had a CCL.