I absolutely use the capacity of my mid-size SUV quite often for a variety of purposes. Don't need anything bigger or the towing capacity of a full-size truck. And, given where I live, renting for a weekend would be very inconvenient. Sure, I could use a smaller hatchback/SUV day to day but I'm not going to own two vehicles at this point (though I used to own a two-seater as well) which some folks would probably also object to.
You pick a reasonable compromise and arguably a full-size truck is overkill for many but a Mazda Miata is probably too small for a lot of people even if it largely works for a lot of day to day stuff.
I own a small/mid-size SUV (and a van) so I’m not judging your car choice, but why would you not be able to rent a truck in Boston? Home Depot, Lowe’s, U-Haul, and more all rent trucks.
I don't live in Boston--about 60 to 90 minutes outside.
So, sure, I could pay for a delivery or rent something from Lowe's if I needed to for a specific purpose but I routinely use my mid-size SUV for weekend trips, transporting a canoe, picking up construction supplies, and the like. I need a vehicle in any case and it makes sense to own a somewhat larger one than I really need day to day to run to the grocery store, especially given that parking isn't an issue and my gas mileage really isn't bad.
If one actually lives in a city (which I don't), renting a vehicle can actually be something of a hassle on a weekend based on what I saw people go through when I was in a ski house after school.
If it’s a regular thing, yeah, renting becomes massively inconvenient because of the frequency. I misunderstood your comment to mean that even a 1-time rental would be extremely inconvenient somehow.
I don't need to transport 8 people around and I can always get mulch or gravel delivered. But, yeah, it's not uncommon for me to want to easily stuff a mid-size SUV's worth of stuff into my vehicle for a weekend or longer trip. I could probably do it with a somewhat smaller vehicle but why? The longer drives are probably when I need to do so anyway.
I did also have a smaller car as well when I did more shorter regular local drives but I really don't do those much any longer other than very local drives to the grocery store or nearby hiking trails.
You pick a reasonable compromise and arguably a full-size truck is overkill for many but a Mazda Miata is probably too small for a lot of people even if it largely works for a lot of day to day stuff.