OP - There is no right or wrong answer. Before you start, go and read every word of the various insurance policies which you may have through your auto, homeowners, umbrella, CC and so on.
Focus on liability. Cars can get repaired. People are more expensive.
I would worry less about flat tires and the like. There should be a clear explanation of what to do with your rental. If not, ask.