The Fusion competes well with the Altima and Accord in terms of value, but honestly the Accord ages better. More people want them, so resale is better. If you’re planning to keep it long-term though, Fusion is fine.
That archive test was fantastic. The way they explained how Quattro gave the 5000S such a competitive edge over the competition really showed why Audi became so dominant in the premium sedan market.
Anyone considering buying one of these should really get a pre-purchase inspection from someone familiar with vintage Audis. The Quattro system can hide issues until something catastrophic happens.