Ok, I'll start, then let the gurus finesse it. It depends on the application- street, drag, circle, etc. Depends on weight, gear ratios,compression ratio, etc. And drivability on the street, if you want street/strip.
I have installed some cams that I wanted to kick my butt over, just trying to get to work. Waaay to much. With a 10.5 adv cr, 340, and a mid purple, my life could be hell, in town; until I learned timing and carb tricks.
Basically; heavy, no gears-advanced. lighter with gears; depends on what the car wants. Retarded- top end, again, what the car wants.
It is a combination of engine (how it was built), drive train, tires, what you want it to do. Street- go fast as you can? That cam will keep you po'ed; just want a little lope? small cam you will love.