Recently dropped collision but kept comprehensive, vehicle value ~$4,500. If I'm an idiot and cause an at fault crash, I have no problem paying for the collision damage to my vehicle. If someone else is at fault, their insurance would cover the collision damage (or I'd be out of luck if they had no coverage and insurance could not recover damages). On the comprehensive side, if someone damages my car, for instance in a parking lot or if there's a freak hail storm, I'd be pissed off paying for it (and comprehensive coverage cost was nominal, so kept it).
If you ever plan to drive anyone else's car (e.g. friend, relative, rental car), just ensure your coverage is sufficient since you/your insurance are on the hook if anything happens while you're driving their vehicle.
If I ever rent a car again, I'll add collision coverage for that timeframe, since the separate rental car insurance is usually insanely overpriced.