The TT is a bad place to start as it is a FWD car until the wheels slip and sends traction to the rear (Haldex). Also, just generally not a great handling sports car.
I've driven Subaru manuals (auto have a different system), Audi quattro, Audi and Volvo Haldex, and BMW's (now old) fixed split system. Fixed is nice and predictable, but I prefer the moving advantages of the Scoobie or Audi system. Between those two its arguing about tried-and-true mechanical vs electronic high-tech. In my mind they produce roughly the same result. Haldex has issues as above (unless it is a 993 or later Carrera 4 in which case the Haldex is essentially reversed with it being RWD and power being able to move to the front). My beef with the e46 AWD cars was the jacked up ride height and the fact that the sport package was seats and wheels, not suspension as well. That's why we bought our A4 1.8T Avant and not a 325XiT.
As for AWD or not, I like the security and traction, but it takes away a bit of the fun of RWD, and adds substatial weight and gas penalties. Up to you. I would like to always have at least 1 of the 2 or 3 family cars be AWD.