I think you have to think about the type of driving you do, or intend to do with the car. If it's a daily driver, and you're going to spend a lot of time in traffic jams - auto is the only way to go. If it is a weekend cruiser, and you drive a lot of windy roads - no doubt a manual. If you want to drag race, or beat everything around at every stop light - auto. If you autoX or road course type racing - manual. I have both right now, and they are both fun to drive.
My C4 is an auto that I drag race with, the ECM has been tuned to shift a specific points, the best possible shift points for WOT - this can not be beat by manual shifting, the best possible senerio is for a manual tranny car to nail it perfectly, I do it every time, so the only thing I have to worry about is wheelspin off the line, and when it is shifting from 1-2. If I race a Z06, and beat it off the line, race over - he can't catch me (of course my car has some engine mods). Point is, I' not bragging at all, that the consistancy of the auto will win drag races, wheather bracket, or Mano-e-Mano. The flip side is I also autoX the same car, and get my butt kick every time by the same manual tranny cars that I beat at the drag strip.