I'd go for a Mondeo Titanium X. If that thing had a N54 engine i'd have probably have bought it
The 140hp Diesel Mondeo is more economical than the Audi A4, don't be fooled into thinking other wise. The Titanium X is loaded with toys, whereas with the Audi/BMW you'll just get some seats and a steering wheel.
The Mondeo and Insignia are huge. Ford and Vauxhall have really increased the size of their cars in the past 10 years. The Mondeo estate is more a match for a 5 series / A6 than a 3 series / A4.
Don't get worried about depreciation either. All cars depreciate. Things like Mondeo's more so, but that means you can buy a hell of a lot more car for your money in the second hand market place, or just spend 3/4 grand less.