I much prefer the driving in a manual car, but that's when I'm actually controlling the car, not just trying to get from a to b without any hassle. My wife's car is an auto, she always preferred a manual, but now with that little distractions in the back an auto box means one less thing to worry about when driving.
Auto boxes are way better than they used to be, just as fuel efficient, can choose your own gear most of the time, no clutch to burn out, 5-6 speed is pretty standard, much easier in traffic.