my 5BW and C6 ZR1 are my perma-cars, not selling them hopefully ever. Peak cars (for me).
Everything else is interchangeable. That said, I'm 48 now and realized driving boring cars is not something I want to be thinking about laying on my death bed. Only truly boring car I had was a perfectly fine, perfectly nice, zero trouble ever '23 Silverado LTZ (with all the options, $68k sticker) 3.0 diesel. So smooth, quiet, comfy, but.......boring.
Traded that perfect truck on a ridiculous, gas guzzling, obnoxious '25 Raptor R about 4 weeks ago. But, guess what? It's not boring.
Anyway, be careful with being too practical as you get older. Life is short. If you want the A6 daily "beater", get it, but don't subject yourself to not having something fun and something worth driving. What's the point of this retirement job if you don't get to continue to enjoy the fruits of your labor in some fashion?
If life was all about practical, we'd all be driving Honda Accords and Camrys or some other vanilla, efficient SUV.