Let's take off roading. Let's say you are stuck. To get out you need to sway your car back and forward, by putting it in first, accelerating, then sticking it into reverse, accelerating, it sways ever so more, and you can get out. This also work with a regular car stuck in a ditch. With automatic there is no chance for this, even if it's a dual clutch, or semi automatic sequential. Only stick shift will do.
Let's take city driving. You battery died, you forgot headlights. You are in the hurry, no one is around. With manual you could push your car and start it in 2nd gear. No chance for that with an automatic.
Another city driving situation, san francisco hills scenario. You are descending. With manual you could control your speed with gear. No chance for that with an automatic. Same goes for winter situations, without electronic assists you will slide with an automatic.
Now for racing. With manual you can clutch brake, teather, correct, gain traction. You can not do that with torque converted automatic. You will need dual clutch, and in some instances sequential race transmission, which your camaro does not have.
Automatic, be it torque converted or dual clutch, is good for stop and go traffic. Nowadays they also say it is faster, especially dual clutch, because it shifts faster. But then again, there will be situations when it is useless and slower, for example some instances of over taking.
Funny thing is this, Russian tanks, including T14, have manual transmission and automatic loader. While American tanks, have automatic transmission, and manual loading.
Automatic transmission is a purely American cultural phenomenon. Try to get a car with manual. Germans you might think have auto as well, but it's different, it's dual clutch robotized manual. For performance driving it all comes down to control, which is directly proportional to enjoyment. With one computer controls how your car drives, with the other you control.