Option A is to use your credit card IF it provides auto insurance coverage. CHECK YOUR POLICY first. If you're covered, you need to check "decline" on the insurance form. If you damage the vehicle, your CC is charged (so the rental company has its money immediately) and then your CC company removes the charges from your CC account, once all the paperwork has been processed. MAKE SURE you read the fine print so that you do all the paperwork required by your CC company - this might include a police report, special forms from the rental company, and a special form from the CC company, maybe more. Also note that, while the investigations and paperwork are being processed, the charges sit on your CC account - could be for the full price of the car. If all goes well, you're covered, but you need to jump through the right hoops to ensure you don't wind up buying the rental agency a new car.
Option B is to pay the extra insurance. This is a good option if you are super risk averse and don't want to risk your CC company screwing you over. Do the math on buying the rental company's insurance. For a week you're probably looking at around $100 extra (if you book online and take all the right options) to $300 if you get burned for full rate, for insurance coverage that basically allows you to drive the car off a cliff and walk away with no hassle.