I'm a Starwood guy. This is not an average Sheraton or even Sheraton vacation property. The grounds are very nice, and well maintained. Everything is clean, the rooms, the linens, and the pools. Staff was very helpful and friendly. The rooms, especially the bathrooms are more what I would expect in the Westin part of the chain. The restaurants are spendy but clean and decent food. The whole place operates on a dollar economy. This is a resort, a little American oasis, not really Mexico. On the plus side, you can drink water from the tap.
The beach is nice but the surf is a little much, especially if you have little kids. it actually isn't bad to swim in but it would toss a child around.
It's well worth it to rent a car and get out and explore. Cabo is very safe and the worst thing you have to contend with are annoying hawkers, very iffy directions and mile markers and drunk kids in the spring break area of CSL.