Its all choice really...
I believe most to think manual is more sporty, and you have more control of the car (since you control gear). If you like to romp around, rev the engine and what not.
Automatic is better if its going to be a daily driver, not for fun but for looks. Automatic is get in and go, you can romp around for sure, but its point and go.
I'm a manual sort of guy, I love shifting, slaming thru gears, downshifting etc etc...its a sport/muscle car thing. I personally think automatic belongs in trucks and 'other' cars or those who don't like / know how to drive manual.
If your looking for numbers, like which will get better gas mileage there is probably another thread listing that. But end all, i (personally) don't think you should choose auto/manual based on 0-60 times or mpg or anything of the such. It should be on what your looking to do with your car.