Manual has saved me on several occasions in the winter. Plus I get much better mileage with a manual. Oh, and you don't have to change ATF. Oh, and auto's eat horsepower. But other than that auto's are ok.
Seriously though, I've looked into auto a bit. It opens up a much larger variety of vehicles. Looking up TSX's on autotrader, there are like 30 in my area with auto. 4 with Manual.

Same trend with TL's.