There are pros and cons to both. However, for maximum performance the manual transmission is the best. It also lets you have more control over its power. If you are someone who likes to minimize your movements while you are driving, mainly when in traffic, automatic is your best bet. It's all about what you want in your vehicle.
Current technology automatic transmissions get much better fuel mileage and last longer than standard shift transmissions which is why more and more cars are coming with them as normal equipment including high performance cars.
Manual trans will last longer as long as they are driven properly. You have a simple gear to gear system. Automatics have many internal nonservicable clutches and bands that are designed to slip. These eventually wear out many many miles before a steel gear.