Cams add power depending on supporting mods.
On a otherwise stock engine some stage 2 cams you will probably see around 15-20 hp.
Now with supporting mods (headers, intake, p&p heads, stronger springs or oversize valves)
you could see gains around 40-60 hp.