It depends clearly on the car, I wouldn't want my F10 in manual, it would just not fit for me, but on the other side I would not want my Z06 in auto either.
As for current BMW M3, M5 I am very happy with the DKG. They are still very fun to drive and you can relax when stuck in traffic.
I think this snobbery is much more present in the US, as in Europe 90% of the people know how to drive a stick shift, very few people make an auto only driving licence, so it is nothing special.
My Garage:435i F33 - Estoril Blue / black leather
Corvette C6 Z06 black / black // X1 25d M Sport - mineral white / cloth-alcantara black