The first dollar in any claim is always paid, the last dollar hardly ever, so the first dollar is worth more. Maximum deductible also reduces the chance you’ll involve insurance at all. Why report a $200 fix when your deductible is $1000?
Comprehensive insurance is for when you CANNOT afford to lose the car. If it would be painful but you’d survive, you probably don’t need it.
As a general rule - You should buy insurance on something when you both 1) have to have it and 2) can't afford to replace it.
Once you can afford to comfortably absorb a loss equal to the value of your car, you should consider dropping collision and comprehensive. For me that's when the car is worth less than around $5k.