Los Cabos is a fun surf vacation destination depending on what you're after. Cabo San Lucas has big hotels, nightlife, a beach party scene, tourist stuff, and restaurants ranging from cheap to outrageous. There is a cool hookah bar/cafe in Cabo I'd recommend called Fumari
http://www.yp.ecabo.net/?2,02709504B4,99.d As for the surf there isn't much happening in Cabo proper. The legit waves are along the corridor, at Costa Azul, on the East Cape past San Jose or back up the Pacific side. If you want to stay at your hotel and surf conveniently out front, stay in San Jose at Costa Azul area (a car is nice to escape the crowds) or at La Missiones or close to there but there is only one break there-Monumentos. I definitely suggest staying in San Jose and getting a car. Driving there is really not sketchy like other parts of Mex.