I traded in my Dodge caravan after 14 years for a RAV4. Have been very happy with it for zipping around town (as has my D!) We also drive it to S’s and now D’s college which is an 8 hour drive; it’s easy to drive on the highway and has good sight lines, but I agree that it’s not the most comfortable car for longer rides. Not a game-changer for us, particularly since we liked the Rav4’s lower price tag, but if you do a lot of travel driving you may want something with more comfort features. For move-in/move-out days and one longer college tour trip (PA to AL) we just rented a mini- van from the Enterprise right down the street from us - that has solved the problem when we needed more car than the Rav4 or my H’s sedan. Have also used it to haul plenty of stuff, with the seats folded down. I think it’s pretty roomy - we only have an issue with cargo space if we have more than 2 passengers and can’t use the entire back trunk.
I too am surprised by how many cars some of you have had - we have kept all of our cars for at least 11-12 years. Except for the one Dodge Caravan, all have been Toyotas!