I think once folk stop regarding cars as white goods and instead treat them as something that needs a bit of care, attention and regular servicing, then questions like this become moot.
I have never, ever taken into consideration either age or mileage when looking for a new car. There are too many people out there (my wife, for instance) with absolutely zero mechanical sympathy. She ran a Ford Ka to the ground and scrapped it within 6 years, less than 70,000 miles on the clock. I, on the other hand, have a 20-year old car that gets used almost daily and runs as well as the day it rolled off the production line.
In other words OP, condition over age/mileage. Try a Zafira VXR if you’re yearning for a bit of oomph in your family wagon. One of those figures highly on our next car shopping list.