Well, the sensible options would be either Michelin Pilot Sport PS2, or the Continental SportContact3. I wouldn't use the Conti SportContact2, as these can be quite harsh at low speeds.
I wore my Pirelli P-Zeros out after 4,500 miles, but I am notoriously heavy on my boots!
The Michelin are better suited to low speed comfort around town, but cope well with "tuning" tyre pressures.
The Contis are more suited to heavy loads and/or high speed Autobahn cruising.
In terms of tyre life - an extremely suggestive situation. On my previous B6 S4, the OEM Conti SportContact2s lasted about 10k miles, and I replaced them with the Mich PS2, and they lasted about 8k miles. The Michelins are a better tyre for extreme use though.
If you only drive "moderately", and don't head for the twisties, either tyre should be more than adequate.
HTH