Welcome to CruiseMates!
Don't be afraid to get out in the tourist areas and to get in the water.
You can look at excursions with private vendors, just do a little homework before your go.
In Cabo the ship will drop anchor in the harbor and you will tender (take little boats) ashore. The ship does pull out at night to open the casino and shops so it's not quite like having an overnight stay in port.