Your camshaft choice depends on the type of perofmance you're lookinf for. What RPM range are you looking to operate in, and where on the RPM curve do you want your HP and Torque? A more racy camshaft will generally raise your redline and cause you to have a decrease in low end torque, while increasing overall performance at higher RPM's. This is good for on-track performance and drag racing, but this could hurt your overall driveability when driving on the streets.
race camshafts, (Or any cam with a hot lopey profile) will cause the car to have a rougher idle (Even force you to raise the idle to as much as 1200 RPM or more). You cash in on the benefits when you get the motor wound up on the tach. The improvement is greater throttle response, more high end HP and a broader torque curve at higher revs. You will probably want to avance the timing a couple degrees too to offset the cam.
As with any cam swap, you're going to want to check and be sure that the springs on your existing valves are going to be adequate for the camshaft you're using. If they ware too weak and you're cam has a very aggerssive profile, the springs may not be able to fully close the valves in time and you may notice that you're not getting good compression at higher RPM's, or even worse, you may destroy your engine if the piston comes up on an open valve. Over time your springs may fail completely resulting in a loss of power and a huge repair bill to reove the top end and replace the springs and retainers.