The State Department's advice is contradictory:

U.S. auto insurance is accepted as long as an individual is a tourist in Canada. U.S. insurance firms will issue a Canadian insurance card, which should be obtained and carried prior to driving into Canada.

I live near the border and spoke to my insurance agent about it awhile ago. He believed they were absolutely unnecessary and I suggest you can safely follow the State Department's first sentence above rather than the second.