As someone who has recently done the whole new family car thing…
Octavia – probably too small for what your describe unless you are minimalist campers.
I would expect the van/people carrier options above to be best for the family stuff you describe. I would caveat i’ve never owned one but based on space and practicality I reckon hard to beat. We nearly went that route.
Then you get to where we ended up which is how many miles it will do empty (ie just the driver) and what will it be doing on those days? In our case that ultimately killed off the van based options because for 12-15000 miles a year I am sat in it on my own on a diet of motorway and a roads. With the economy and performance loss it ended in big estates. I’ll stick the bikes outside and ram everything else in for the big family trips.
If we need extra seats to lug elderly relatives on a long trip once a year we decided we ‘ll rent a Galaxy and tolerate the cost (for anyone who remembers my seven seater/moon on stick thread).
I bought a passat DSG in the end. From driving several of each the Mk4 Mondeo drives better. It’s boot is bigger I o would say/guess. Passat of same age had satnav and a fraction cheaper so it won.