Stick is funner... but if you are buying a new car... definitely automatic.
Reasons:
Pro-Auto
-Automatic has more resale value ( hardly anyone can drive a stick anymore, go look at the kbb if you don't believe me )
-Easier for excessive stop and go driving, like where I live ( a large urban area)
-You can do other things while driving ( this will get me flamed, but the easiness of driving an automatic is obnoxious compared to manual )
-You can't kill your car on accident and embarass yourself to your passengers ( I know many experienced manual drivers that have done this simply because they were talking to passengers)
-The car is much more predictable and you can adjust easier to unusual situations ( such as excessive rain/snow/ice )
-If you are bracket racing, much more consistant ETs
-You don't have to have as much concentration, so can drive ( theoretically) safer while tired
-No clutches and torque converters often last way longer than clutches if taken care of
Pro-Manual:
Performance- Better control fo engine revs for max performance
Better fuel economy- By probably 10% on most modern cars. On old cars, the difference is dramatic.
Concentration- Helps you concentrate you on driving unless you want to look like a jackass or be unsafe
Novelty-Driving a manual is fun to a certain extent. Except sitting in traffic. And it might impress a female or two.
Cost- Cheaper. But not really so much anymore. Especially noticeable in used car market.
Maintenance- You should never have to change a manual transmissions fluid, but you should change an autos fluid every 100k or so.
EDIT: Whomever says manual is better in traffic needs to drive an auto more. You don't have to hold down two pedals, but only one in stop and go conditions(unless you make 300 shifts into neutral, which is unlikely). That is absolutely silly saying manual is easier to drive in stop and go conditions, when all you have to do is release the brake for automatics and never have to shift or clutch. For persons of my size (6'4") that means a world of difference in comfort as no car fits me comfortably to begin with. Call me lazy, but I'll leave the sticks to 'fun' cars ( I'm looking for a triumph spitfire
)