What nobody tells you is that in the city, a sedan kills you in another way: fuel consumption depends a lot on how you drive in traffic. If you're accelerating and braking all day, stopping every couple of blocks, even a decent sedan is going to burn more gas than you expected. A compact SUV isn't that different in that respect, honestly. The real difference is parking: downtown, a sedan fits in spaces where an SUV won't. That's actually concrete.
For weekend trips, the question is whether you really need that extra space every time or just occasionally. If you travel alone or with one person, a sedan is more than enough. But if you're bringing family or camping gear or something like that, the SUV gives you more peace of mind. Maintenance is pretty similar between both, it depends on the brand and how well you take care of the car.
What's worth checking is whether you can go with a smaller SUV or a bigger sedan. Compact SUVs these days use about as much gas as a sedan and give you that space you sometimes need. And here's the thing that matters: calculate how many trips a month you actually need that huge trunk. If it's two or three, rent a car when you need it - it's way cheaper than paying all week for space you don't use.