You didn't mention anything about a particular car rental
budget (no pun intended), but using the Southwest code (you don't have to do it from SW's site, just punch in "U072700" in the BCD code on Budget's site) you could get a full-size for 10 days for around $273, taxes and fees included. And then if you happen to be a Costco member, apply coupon code MUGZ029 for another $30 off at check-in. But you'll probably have to show your Costco card, so try at your own risk if you're not really a member. Or try coupon MUWZ023 for $25 off. Requires 5-day rental and Saturday night stay, which you've got covered if you're staying 10 days. Budget with SW's code is by far the best deal going right now. I'm still holding out hope that Alamo will get over their bout of insanity, but in the meantime I've got a full-size booked with Budget for $243 (with Costco coupon) for 10 days, 10/20 - 10/30. I'm pretty happy with that rate, compared to the alternatives.
Seriously, you'll never fit everybody and everything in a compact. There are only two of us when we travel - 2 large suitcases, 4 small carry-ons (laptop bag, camera bags, etc.) - and we usually fill the trunk of a full-size.
*** EDIT: Good thing others think you can fit in a compact. I just checked Budget's rates with SW code and they're back up. Full size is now $533 for 10 days.