The 2.0TDi is the perfect choice for your requirements although I'm not sure the quattro is really necessary on anything but the 3.0TDi.
I tested the 2.0TFSi (very quiet but needs revs) and the 3.0TDi Quattro (awesome pulling power and very smooth) before opting for the 2.0TDi (pulls better than the TFSi and with better economy) but decided I would rather have all the extras available with the S-Line Special Edition over the Quattro with just Sport trim.
Please don't take this as gospel, this is just what I preferred.