I always rent from Hertz, due to my (ex) employers discount, and I always take out max insurance (well now at least, perhaps not always previously). Now I never receive even a cursory check when returning, so money well spent.
However, in previous times, I did have a rather unpleasant...