We have the Le Mans 3L TDi version of this ('57 plate) and love it. It beat the BMW 3 series and the Mercedes C class equivalent hands down on size and responsiveness. For size, the Mercedes E class is bigger but again the car felt more pedestrian.
The boot is cavernous and if you really need it, a top box is surprisingly light on the fuel economy, particularly when fully loaded. Plenty of room for adults front and back, although if you've two child seats select slim grown ups only for the rear seat! The only thing missing for me is a ski flap in the centre as with two children in the rear it is not always practical to use the 1:2 rear seat split when carrying long items.
Fuel economy is good on long journeys but not so good on short ones, even in the computer controlled drive mode. It eats up mileage easily on long trips. Manoeuvrability and visibility are good for such a big car and the parking sensors are good too, though I have seen more sophisticated all-round systems, not just front and rear, on BMWs. We've driven it down entirely iced up back roads through the last few snowy winters and found the 4 wheel drive, ABS and traction control good enough for a necessary if cautiously driven trip.
The ride is quite stiff but it is a sport model so I would expect that. I find the leather seats perfectly comfortable even on long journeys despite this. Seat heaters in the front are a bonus; electronic memory seats would help as getting driving position right can be a fine art.
The Sport mode really increases the engine responsiveness and reduces (but not completely eliminates) the turbo lag in Drive. The lag can be quite frustrating as it is not consistent - sometimes you put your foot down and the lag seems long, sometimes short. Might just be perception though. There are flappy paddles and a gear select on the gear stick if you need/want them.
The downsides: the MMI entertainment/info system is not the least complicated and (in ours) doesn't support MP3 players, nor does it have a single CD loader. The satnav is poor, taking only the first part of a postcode plus the first number from the second part, leaving you with a wide geographic area to try and narrow down. Updating the maps with official Audi ones is very expensive - to the point where we will simply go and buy a separate satnav plus updates when we need new ones. Parts, particularly tyres, are very expensive and if buying second hand check the duty band carefully as Audi changed the engine for a lower band one around 2007 but some later plated cars may still have the older, higher band.
In short, this is a good family car with some niggles. It has its expenses but the build quality is such that I think it will last well, hence my value for money rating is better than my complaints about pricey parts might suggest. I would definitely look at buying again when we've run this one into the floor.