In my opinion, the best courses in Cabo are Cabo Del Sol--Ocean, what used to be called El Dorado--which was quite scenic a few years back, but has now been riddled with housing, and La Querencia, a private Fazio course.
Others that are good include Cabo Del Sol Desert Course by Tom Weiskopf, and the 27--hole Palmilla Course by Jack Nicklaus.
Cabo is one of (perhaps THE) most expensive golf destination in the world, so be prepared, and hopefully summer rates are more attractive..