The only downside to renting is they may not have inventory on holiday weekends. I've never had this problem.
You will this year if you try, given what a disaster the rental agency inventories are right now.
Every other time they either push me to upgrade, or for whatever reason upgrade my car for free. I usually decline because if it's just me with a carry-on I'd prefer not to pay the extra cost of gas. When I've needed a full-size/SUV I've never had a problem.
Although, one other issue is the widest selection is near an airport. If you're taking a road trip and not flying you may have to drive to one.
About two thirds of the cars I've rented had issues with tires that are balding and leaking air. I wouldn't call that "well-maintained," and I'd have concerns about renting one for a long road trip. I now carry a portable air compressor in the trunk of every car I rent.
https://www.kbb.com/car-news/5-tips-on-buying-a-used-rental-...
"rental companies typically keep their units on strict maintenance schedules. They can’t afford the downtime from unscheduled repairs, so you can be fairly sure that the vehicle is in top shape."
That's been in line with my experience. I'm not brand loyal. In general, the discount brands do have older cars. The name-brands usually had current or last year models. The larger vehicles were almost always brand new unless they were specific to hauling. The only time that hasn't been true was when renting in Iceland. The vehicle was at least 10 years old (maybe 15 or 20?) and we were driving it to remote places. So I was a bit concerned about breaking down and access to help. Thankfully, it never had an issue.
I'm sure certain things like a winch might be hard to get. I know I've specifically requested 4x4 a few times and I've never had the need to ask for tire chains. If you have a particular need, like towing something or you like to go mudding, you'll probably need your own vehicle.
That's just unacceptable to not provide a jack. I know some vehicles, like Mini Coopers, have run flats and don't even offer a spare or jack. That always made me uncomfortable (and it sucks to pay way more for tires with a worse ride).
You may also be limited by the drop-off/pickup times. Road trips often have very early departures or very late returns.
I have a headache just thinking about re-installing 3 car seats for every weekend hiking trip...
Things become significantly more painful when you have kids.
I don't know how the economics work out for that - it probably depends a lot on both the family and the car - but, based on my experience of many years not owning a car myself, and going to the Hertz down the street when I needed one, I wouldn't be surprised if it can be made to work out reasonably well.