Not going to offer you DYNO testing results, but just a simple statement on what they do that is bad and good
Used in an engine like a stocker they will increase the engine torque a tad by making the total intake tract longer which creates a stronger ram effect.
However with this increased length it has greater flow resistance and can dampen the top end rpm a tad.
Used in a Modified engine with advanced intake duration, the ram effect of the charge in the intake tract is not as strong even tho flowing at a higher rate. The larger size of the modified intake tract & manifold can create fuel spit back issues, The use of a stack can actually increase the ram effect enough to take away most of this reverse flow spitback making the engine run smoother and carb stability better. The flow restriction is still present, but controlling the spitback issue and the power gained by doing so can in some instances be worth the addition of a stack.
No hard and fast rule, but understanding the dynamics involved allows you to apply this in your final set up.