Plodding around backwards and forwards to work I wouldn't mind an auto but if I want to give it some I do going through the gears. The constant whir & drone of an auto would make me go nuts.
This is why the DSG and SMG boxes are great, manual boxes that have been autonimified (trademark).
I was semi looking at Golf GTis (mk5) a while ago and was discounting anything with DSG outright, with no real reasoning apart from eww it's an auto.
Then my step dad was after an R32 and one we looked at was a DSG.
Wow. It was awesome, compared to driving the manuals that day it felt loads better and also made the car feel more 'special'. It's a pity he couldn't find a DSG model he liked so went for a manual, but even he (who hates autos) said he's still tempted to swap it for a DSG model in future.
So now if I go down the Golf or M3 route I'll definitely be considering any of the autos.