I've driven my 5spd manual A4 in it's flavors from bone stock to where it is today at a full 1+ setup. Drove a couple other B6's on several other occasions (frineds' cars) including:
03, Tip, 1.8t, Quattro, sport, stock (engine wise)
03, Tip, 3.0, quattro, sport, stock
04, 6-spd, 1.8t, quattro, non-sport, stock
05, 6spd, 1.8t, quattro, USP, stock
IMO the automatic isn't bad (better than other stock auto's I've had), but as has been stated i felt somewhat disconnected with the car and less in control especially when you decide to have a little fun with it. When driving it spirited the Tip just didn't give me the gear i wanted at teh time I wanted it(in Sport mode or not) and there was nothing I could do to it...so I wouldn't even consider a Tip B6 as I like the connection and feel of the manual trans. Go drive them as see for yourself. I haven't driven any (engine) modified Tip B6's but hear the shifting is worse as diagnosticator eluded to(...and I know I didn't like the shifting stock!)
Bookmarks