I've been to Cabo as well as Casa de Campo.
I've played 9 holes (2x) at Cabo del Sol on the ocean course, and Querencia.
Querencia was typical Fazio golf--hit the fairway or be done. Cabo del Sol (the 9 holes I played) was excellent.
That said, I think Teeth of the Dog is a PHENOMENAL golf course, especially the ocean holes.
In terms of a stay and play experience, Casa de Campo is one of the finest I've experienced. Airport (relatively) on-site, a fantastic resort with tons of amenities, great golf (there are 4.5 courses now on the resort), etc.
Cabo I really didn't like the having to drive all over/around everywhere and the "time share" mentality of the places--and I was staying at a 5 diamond property--immediately adjacent to the cabo real courses.
If I had to do it again; I'd choose Casa de Campo in a heartbeat.
(That said, I really want to come back and see the newly revised cabo del sol ocean and diamante)