Hands down the location in the southeastern Mexico- Caribe de Mexico- The Cancun/Playa del Carmen area is best of the best I've seen in Mexico. Ambassador bholey recommends a great location and golf is a part of "all inclusive".
Cabo is an amazing destination for golf, fishing, nightlife, food/bev. and not to mention relaxation as well.
My choice, even though we have a place to stay in Cabo, would always be Cancun/Playa del Carmen - the Mexican Caribbean area.
If you plan to play a lot of golf- even more so- chose to go to Cancun/Playa del Carmen. Check out the golf course in the site- it will not disappoint.