I was advised to get one when driving from Detroit to Windsor; the DTW Avis didn't have them at the Preferred Counter, so I had to go to the main building.
They also suggested it wasn't 100% necessary, but I insisted and they gave me some little paper insurance card to throw in the glovebox. It seemed to contain no personal information.