Audi A6 Avant Replacement?

Ok, so our current A6 Avant is nearly 9 years old, with a modest 80,000 miles on the clock and we’ve owned it since new. Great car and perfect for our needs (eg we can get 2 bikes inside easily with seats down). Typical use is motorway trips to visit family and for holidays, one long European trip a year and local journeys.

So, our dilemma is:
1. Do we replace it while it still has some residual value & get another A6 Avant (which we would be very happy with), or something similar like a nearly new Volvo V90, Merc E-class estate, Skoda Octavia estate etc. We would be buying petrol or diesel (not electric) and we would most likely keep it for another 8-10 years.

2. Do we run and maintain the existing A6 for another 5-10 years? (the 2.0L TDi engine will easily take the mileage). However reliability concerns us as the car gets older, particularly for European trips.

Option 2 is probably the most financially prudent but it’s not the deciding factor for us. There’s the emotional decision of having a new (or much newer) car and enjoying that for the next 8-10 years. There’s also the fact that estate cars of this type sadly seem to be a dying breed and if we wait another 5+ years, finding a suitable big new estate may be well nigh impossible, as the world gets taken over by SUV/Crossover vehicles.

Any words of wisdom greatly appreciated, especially from anyone who’s been through a similar thought process.