Thanks everyone for your replies!
Looks like I may not be able to do Cabo after all, turns out there are no direct flights from NY. I can't put all of my friends and family through that, especially the elderly ones. I also need to pick a place where the ride from the airport to the resort is no longer than 30 minutes. I never realized there are so many things to consider when planning a destination wedding.