Currently at Cabo Azul. Picked up a rental from Hertz for $113 for a week. Of course they tried to sell us SLP and CDW. I told him I will pass. He tried to tell me my reservation does not include liability. Told him I made the reservation directly on Hertz website and all reservations include minimum liability. I reserved with them before in Cancun last year. He was able to find my reservation and he gave up trying to lie to me.
At that price, even if you just park the car at the resort, you will still come out ahead. Plus
If you have never rented in Mexico, be sure to take a 360 degrees picture and video of your vehicle before you leave. Take your time. The staff will also take pictures but always good to have your copy.
If you have rented or driven in Mexico, then the experience is pretty much the same although I prefer driving in Riviera Maya/Del Carmen than Cabo area.