Shudder issue aside, I've never met anyone regret buying a manual transmission Camaro (or anything for that matter).
Plenty of people regret buying the automatic when they could have bought the manual.
I'd say get the manual if it's something you're willing to learn properly. Once you master it you'll never want to go back. You will inevitably find yourself going out for drives for no good reason other than to simply drive your car