So, considering all this
and the benefits of paying less than X $ damage amounts out of pocket yourself,
at what time period ( or vehicle resale value) should all collision coverage be dropped?

When a new vehicle is 3 years old, 5, 7 etc?