The late B8.5 S4 Avant are really holding their money well, partly as the replacement was a diesel.
B7 is fun to drive hard, but newest cars are now at least 13 years old, they are transitioning into a semi classic, with the cheaper less well cared for examples becoming a liability to the wallet.