Different horses for different courses.
If I lived in an urban area, I would probably have an auto in my DD. I found the constant clutch work while we were in Toronto last spring to be not to my liking.
My cars have 5 speeds as did my previous truck. Unfortunately that particular F150 was light duty and I was concerned about slipping/burning the clutch on the few occasions when it was heavily loaded. The current F150 is auto (and much heavier in spec), so I don't have to worry about that.
I do however have the Pavlovian urge to push a non-existant clutch pedal when coming to a stop.
I do like working the gearbox and the comment above about an automatic transmission allowing the driver to concentrate on their driving instead of shifting is indeed true for some. I find after over 40 years of driving manual transmission vehicles I always seem to know where I am in the gearbox and the motor control is almost unconscious. All the thinking about whether the shifter is moving to the right or left, forward or back, where the clutch pedal engagement point is, all that is in muscle memory.
When I drive in the UK, it is interesting how much of that has to be re-learned simply because it is the left hand doing the honors.
Best
Les