Try the forums at
www.audiworld.com. My wife drives an S4 Avant and we love it. My sister has an A4 1.8T Avant, and loves it too. My sister's car is for sale if you want an automatic silver wagon.
Newer Audi's have a very high level of fit and finish, especially compared to the "German Camry" that low-mid-level Mercedes have become. Like all cars these days, they're way heavier than they should be. If you're tall between butt and head, you may have headroom issues in a pre-2003 A4/S4. The newer version has a roomier interior and more headroom.