For the weekend? Rent an SUV. The problem isn't that you go on a weekend trip with it: it's that you drive it to the store every day.
Rent an SUV? That's your solution? So I should spend an extra $200 (3 day rental + tax & fees) every time I want to take a trip in addition to my monthly car payment just to make you happy?
I'm just not that invested in your happiness.