Not sure of anybody who has put that cam in a Camaro. Looks like you have long tubes, exhaust and a tune? This cam would give you a little more power (maybe 30hp), but you may actually lose a bit of torque as well. The LS9 cam is focused on use for a supercharger, and towards pleasing the average customer who is not power hungry. It wouldn't make a great naturally aspirated cam, unless you are definitely going to go forced induction down the line, and even then, its a very
mild cam. Either way it probably wouldn't be worth the cost/time of installation.
As you probably know, our L99's are equipped with Variable Valve Timing, and Active Fuel Management. When swapping cams, these things must be removed, which means pulling the heads, replacing the lifters, the engine valley cover, the front cover, and the cam sprocket. It's quite a job on an L99 engine, and therefore would probably not be worth it to put a little cam in. The good thing about it though, once you have done these things, they are good for any other cam you choose to install, and takes a lot less effort/money to replace it again down the line if you want to upgrade further.
It is possible to change the cam without removing these things, using a VVT cam, but cam choices are very limited, especially if you retain the stock lifters. The AFM lifters are very weak when other valvetrain components are replaced with stronger parts. Even in stock situations, they can and do fail.
Don't let me discourage you, replacing the cam and getting rid of these things is a spectacular mod, my favorite to my car for sure: the power, the sound, the rock and roll, and the freedom from the AFM lifters is awesome! But unless you plan on doing the work yourself, and want to do a lot of work, I'd spend an extra couple hundred and get a good cam, you will be much happier.