Even I used to think I love driving manual. But driving day in and day out in sow traffic wears you down and finally I shifted to Honda City AT around 6 months back
The comfort of an AT is unbelievable and to be honest you can never change gears so quickly as the Honda AT in Sports mode. I have a OBD-II bluetooth dongle which calculates 0-100 times very nicely and the AT always beats my manual timings. Offcourse, in terms of mileage there is a small difference but it is very little, unlike the earlier ATs. Nowadays its only if you keep it in Drive all the while when you are stopped.
I was so skeptical while buying an AT that I tried all types of cars in all ranges and after settling on honda city AT I insisted on getting paddle shifts (where you can shift gears up or down from the steering wheel through two small paddles) since I thought that there will definitely be some situations where I will want to change to a different gear than the AT.
But believe me, I have not had the chance to even TRY the paddle shifts EVEN ONCE ! The gears are always perfect and it makes no sense to use the paddle shifts.
Off-course, you need to get a feel of the auto tranny and also know how to nudge the accelerator up or down to signal your intention to the car. If you haven't got that then no AT can predict what you will want to do next. It can only react to what you are doing now. So if you suddenly feel the urge to race, press down hard on the accelerator and it will downshift 1-2 gears and vroom ahead. And if you feel you are going to drive really relaxed but the AT is still on a low gear, just ease a little on the accelerator and it will upshift.
Funniest part is that after driving manual for decades, and AT just for 6 months I tried driving my brother's manual car and kept forgetting to change gears while thinking why is the car making so much noise ! Never thought that will happen.