I make back the cost of the membership fee just by the savings on a couple of car rentals. Their rates are cheaper and they have free cancellation and no extra driver fee for your spouse.
I've found car rentals for way cheaper than Costco directly on the car rental website. The prices are changed constantly, so check the car rental company's website a day before or even a few hours before you need it, and you might find it for much cheaper.
I do that, but on the Costco website. The free cancellation means you can book and then cancel and re-book when the price drops. It's also easier when Costco is aggregating all the prices for easy comparison.