Where I live manual is the norm, but those I know that did switch to auto all to prefer it. It apparently makes the drudgery of sitting in traffic more bearable.

However, as one friend noted, once that fancy automatic gearbox goes legs up(and your car also happens to be out of warranty), the virtues of a manual comes calling again.