We recently stayed at the Sheraton Hacienda del Mar.
First, let me say that my husband and I have traveled all over Mexico, and usually stay at adults only, all-Inclusive resorts, so this was a different experience.
If you are looking for a QUIET resort, this is the place for you.
We stayed in an ocean front room, which was clean, neat and nicely appointed. In addition to being a hotel, there are timeshare units, which are connected to this property. Both the hotel and timeshares share the entire property including its restaurants, beaches, pools, etc. Upon check-in, you are given a welcome package, along with a pitch to come listen to the timeshare presentation for a $200 hotel credit.
The property is situated between downtown Cabo and San Jose del Cabo, so it is an easy cab ride, but cost for a cab is $20 each way into town, and half that using the hotel's shuttle service, and other than pools and a nice beach (which they recommend not swimming in), there's not much to do so going into town gives you options.
Frankly, I was not wowed by the experience. While the hotel, grounds and our ocean front room was clean and well maintained, the food was "adequate" and pricey (for example, the breakfast buffet cost $53 a day for two people), and there was no nightlife to speak of. On the upside, the hotel staff was great. Always courteous and friendly, as has always been my experience while traveling in Mexico.
Overall rating: Adequte. I just wasn't "wowed".