The car will be my main drive and using it for commuting as well as, hopefully, for weekends away biking, walking, camping etc. it will also be our car for the next 3 years and hoping to have a dog and our first child so the car needss to be suitable for all the associated stuff with these.
I pretty much have the same car criteria as yourself and need to be able to transport 2 dogs and a bike.
I would say go for a Berlingo, especially if you throw a dog into the equation. Consider how you are going to transport the dog, if you’re going to use a travel cage; it’s pretty much impossible to get a cage, bike and luggage into an estate car.
Even the largest estate car is very limited in height compared to the likes of a Berlingo and you should be able to get a dog cage and multiple bikes in whilst only needing to remove the front wheel. An estate car will probably need you to dismantle the bike.
After having the same needs myself, I ended up with a Peugeot Expert Tepee. I actually went to go an buy a Berlingo, but they had a huge discount on a pre-reg Expert; so ended up with that.
The Mondeo will obviously be a much nicer drive than the Berlingo, but there is no point paying out for a car if it doesn’t do what you need it to; no matter how nice it is.