This is a difficult question to answer in that one man's "wow" factor is another man's "meh", but I'll give it a shot.
Imagine that your Camaro has both the 6.2L engine and an additional 2.3L-ish engine...somewhere in the car. With a PD type forced induction, both engines would build power at the same linear rate and both feed the back wheels. Kind of like a huge big block engine. Lots of torque off the line and steady power build. The centrifugal FI will have somewhat the same pseudo-second engine feel, but the second engine would build the power (torque) slower than your main engine, the 6.2L, at first, then would quickly start building power faster, roughly the square of the RPM. This is a pretty crude example, but hopefully you can imagine the difference in the feel of the power delivery. We like to pontificate in this sub-forum on the differences, but in reality, they both can put a grin on your face every time you drive them. Instant torque pulling from a stop with a PD(which I really like) verses a snappy buildup in power once the car gets going (Centri). Not a huge difference for the basic SC setups.
Like any other mechanical "thing" some people won't be able to respect the added power and take the time to build experience with the new power to weight ratio. Other are fearful that they couldn't handle the power; and I agree that there is some point that more power doesn't translate into more fun. (I haven't found that power point yet, but I'm still looking for it.
) I was side stepping the car out of the corner for the first 200 miles with the added power. Now I feel very comfortable with my setup.
To me, I have finally found the right combination of power, cost and handling with the SC Camaro. There isn't too many cars in the world I can't run with, or, you can take it out for a Sunday cruse for leisurely wine tasting, like I do. You're gonna love it!