From the research I've done, there isn't a single villa in Cabo that allows you to rent for only one night. So if that is your plan, you might not have a lot of luck. If you're OK with the night minimum then you have lots of options. I didn't want to stay more than 1 night so we ended up booking the Imperial Suite at the Fiesta Americana which feels like a private villa but it's part of a resort so they do the catering. The food and bev costs are not great though, I agree with you there!