Crower stage 1 cams car not that much different that stock. Designed for low end to mid power, no need to update the valve springs, doesn't mess up your idle. Pushes the peak of the powerband to the right, so now power runs all the way to the rev cutoff instead of dying hundreds of RPM before the cutoff. Nice thing about that, is that you can get away with basically zero tuning, literally drop in and go.
The stage 2 cams are a little more aggressive, idle will be messed up and they highly recommend new valve springs (heavier to avoid floating), a their powerband favors the higher RPMs and is push much higher than the stage 1 cams. They make two different sets, one for forced induction - the other is for naturally aspirated engines. Both work best with tuning, the OEM ECM will be confused if you run these cams.
You haven't mentioned any tuning or your plans for tuning (any way you look at it, this will likely be the most costly single "part" of your mod). Assuming that you'll try it on the stock ECM at first - the stage 1 cams will be a better choice compared to the stage 2.
As for performance, the Stage 1 cams will out run the stock cams, as they are profiled and setup to make power in the same way - off idle to mid-band. Where the cam shines is the upper revs before the car shifts - the stock cam drops on power, while the stage 1 is still climbing.
Now with an automatic - you will not be able to take advantage of the high RPM power sell, as it will short shift every time. Even manually shifting, you'll likely hit the limiter before you can cleanly shift (that lag when you move the shifter lever and the transaxle responds) and end up running slower. Still, all other things begin equal - if launched and shifted the same way - the stage 1 cams will out perform the stock cams.
If tuning and internal mods comes into the picture - then the higher staged cams will, by design, start to build more power. Idle will be different, sounds rough or lumpy, you'll loose the lower end powerband, but make up a lot more at the top end. Since the engine doesn't have a whole lot of displacement - the powerband will tend to be strongly peaked at the upper revs. What you have to deal with here is your automatic transaxle, as it will now bottle neck the performance gains of these cams (need to modify the stall speed on the torque converter, possible update the line pressures inside the valvebody, change shift strategy, etc.) Fortunately, Monkeywrenchracing does sell the updated transaxle valve bodies on their site.