Many people use CC coverage and have been perfectly happy doing so. Just be certain you know what is and isn’t covered. Pay particular attention to normally optional coverages (vary by company) to know if they are covered. Optional coverages could be personal injury protection, roadside assistance, tire and windscreen damage, and believe it or not, theft. Liability insurance is mandatory and included in the rental price.
The rental car company may ask for proof of insurance, so as Jules mentioned, contact your CC company and have proof sent to you.
At my age we spend the extra money and get zero deductible. If anything gets damaged I just drop it off and walk away.
Mo R exaggerated the driving conditions to make the point that things can happen. Cities can be a pain to drive in, but once outside of cities, towns, and villages, there is little traffic. Regarding parking, if you know where you’re visiting you can look up parking lots before going over. There are free parking lots in most places, but you need to know where they are since they are seldom marked. You may need to walk an extra five minutes to reach the center of town, but you can save some money.