Here in europe the standard is manual, so I drove manual all my life.
But the daily traffic jams made me go with an auto for my current car.
I took the geartronic thing (that's how volvo calls it), but it's complete **** compared to manual. Manual isn't only diciding WHEN you want to change gears, but also HOW you change gears.
All the control you have driving manual is gone, even with geartronic.
That being said, I love the luxury of having the auto in daily traffic.
Gas mileage is a lot worse though. But I bet AWD doesn't help there either...
On the ease of use when drunk I can say that changing gears hasn't ever been a problem. Usualy, if you can't change gears anymore, you should stay away from the wheel because you're way too drunk.