I got rid of an 02 Focus a year ago, ended up with an 07 Passat after a bit of looking around.
The A4 was too expensive (was looking at something almost 3 years old for same money as a year old Passat) and ultimately too small – can't stand an MTB upright with front wheel and saddle off so no good for us for French road trips. Would have needed an A6 and simply too many beans for one of them.
I basically ended up choosing between Mondeos and Passats and the difference in residuals between 4 year old Mondeos and Passats swung it. The Mondeo (new shape) is as well banged together and possibly slightly more involving to drive, but the Passat is the 170PS version (which is nice!), very comfy and should be worth 2 or 3k more than the Mondeo when time comes to change once I've had it 3 or 4 years.
Did consider things like a Legacy, Accord and Mazda 6 but there are very few about so soon gave up on that. I think Vectras are just appalling things, didn't even bother looking at them. Mercs and 5 tourers were same issues as A6s.
Only downer on the Passat is that, seats up, the boot is smaller than the Focus as the wheel arches intrude significantly. I can get a road bike in no probs; the Soul fits with a bit of wiggling but have to take the rear mech off my large Rush to fit it in. Otherwise it's all good.
Loads of space – we can get 2 people, 2 MTBs, 2 road bikes, 3 weeks worth of kit and almost 100 bottles of wine inside without any probs – could still just about see out the back window as well.