Had a 1.8 petrol Mazda 5 for 11 years and it was a great car for us. Despite teaching the kids to be careful opening doors in a car park, they might forget or the wind catch the door - the sliding doors on the 5 were one less thing to worry about. Not the most refined at motorway speeds (although I think later versions had better soundproofing), but it was practical and I liked the sliding and reclining middle seats to adjust boot space or rear legroom. The final row seats were used occasionally over the years - bit tight, but they did the job and folded away neatly.
The only issues we had over 130,000miles were leaking front struts and worn front suspension bushes, but it was well looked after and regularly serviced. Other than that it didn’t put a foot wrong, although a neighbour’s son had a diesel one and had several engine problems before he got rid. For the relatively compact exterior size, the inside space was great and cleverly packaged. As badbusdriver said, a lot will depend on how it’s been looked after, but if you can find a good one it’s definitely worth considering.