I have gone before and wasn't impressed. It is a desert and many of the resorts are quite secluded.
This time we stayed in San Lucas next to the marina/downtown and on a great beach and it was one of my favorite trips.
Cancun has more interesting things to explore like ruins and jungles.
If you've never been to either, you have to visit the archeological sites in Cancun. If you prefer perfect weather, laid back and sitting by the pool, pick the location that has the best weather that month
We switched from Cancun to Cabo last minute because it was raining in Cancun every day. And we had sunshine in Cabo