As far as vehicles are concerned it's all a compromise!
However, as you experienced, your vehicle must not work against you, and yours clearly did, so had to go.
The vehicle I wanted, I couldn't run on my budget, so I sought something I could, but that didn't have standing room in the cargo...