There's not just automatics anymore. There is CVT and dual clutch. Cars like the Nissan GT-R, most Ferrari's and lambo's, all have dual clutch transmissions.
Dual clutch is cheap and easy to maintain, similar to a manual, but when it goes out, you do need 2 clutches.
CVT is pretty new technology, it uses a planet-system thing or something. Repairs are similar to an auto. CVT is more optimized for MPG stuff.
Automatic is fine but if something goes wrong then it's basically pull the entire transmission- most just swap in a used one.
Manual is cheap to maintain... The reason being is if the clutch begins to slip, you have to replace it or it won't run. That is your insurance for your transmission so no replacing the entire transmission.
If an auto/CVT goes out, your transmission is basically done if you get to the point where it doesn't start because of it.
But automatics will generally last longer simply because you are not manually moving the clutch. But someone who knows how to move the clutch properly should out last any auto.
Auto's and CVT are also more complicated compared to manual or dual clutch auto.
Shifting in a dual clutch is a lot faster compared to a CVT or a traditional automatic. But automatics in the C7 'vette and the Hellcat's can actually be good too... It really depends on how much $$$ manufactures spent on it.
I've owned 2 manual cars and it's a nice insurance for anti theft and my transmission. If I lived in a busy city I would probably go auto and build the transmission.
@Tenacity
The reason for auto vs manual in Camaro's is because of AFM and VVT. They stand for 'active fuel management' and 'Variable Valve timing.' These are only in the automatics.
AFM will shut half your engine off if you're driving around slowly. If you're V8, you don't actually have an LS3. You have an L99, the biggest difference is the heads, and crap lifters. That's why some v8 owners can get 20+ MPG in the city. Massive power difference as well.
Also, the only 5th gen Camaro that came with 500HP is the Z/28.