"Back Pressure" is pretty much always bad for "performance", and the term is misunderstood and used incorrectly quite often.
You basicially always want to keep the exhaust flow/pulse moving (i.e. velocity). One of the things that will cause the exhaust flow/pulse to slow down is a rapid drop in temperature. Hot exhaust gases expand immediately when given the chance, cooler gases are denser and slower (you start losing velocity).
For example, going from a small hole such as the exhaust port in the head of a Raptor 350, to say a huge 4" diameter header causes a few problems:
* Drops the exhaust velocity almost immediately
* Rapid expansion of hot exhaust gases
* Super rapid cooling caused by the above
* Substantial turbulence caused by the above
A properly sized header will generally keep the flow rate up, but it will still lose heat quickly, the difference is in the way in which it loses heat. Remember, the second the exhaust gas leave the cylinder, the gas starts cooling, its getting denser, and slower by nature (this is why keeping the velocity up from the get-go is important).
A lot of people call the above properties "back pressure", which is essentially incorrect, theres a piece missing, read on:
One of the side effects to a properly made header, thats spec'd to the engine its on, is keeping that exhaust pulse moving quickly (it has velocity and momentum), as it travels away from the exhaust port/valve it creates a low-pressure area behind it - i.e. creating a slight vacuum in the header right in front of the exhaust valve.
So what happens when the exhaust valve opens again? Theres a slight vacuum there that actually helps suck out the exhaust gases from the cylinder. Theres the performance
That is called "scavenging". Scavenging must be tuned properly, pulse frequency, temperature, header/exhaust length (and other stuff) - all play factors in doing this correctly. Thats why time and testing is necessary to get it right.
Do it wrong, and you'll have exhaust pulses doing all kinds of weird stuff, piling on top of each other, causing massive turbulence, etc etc. That can potentially cause restrictions in the exhaust, i.e. loosely "back pressure"
Back to the term "back pressure" it does also exist in the sense that manufacturers do intentionally restrict the engines performance by placing a "cork" on it (usually a muffler with super small diameter exit), then they'll restrict the intake to match the flow characteristics of the other end. They do this for any number of lame reasons - noise being the big one, and also making sure that model doesnt have a chance of competing against a higher model stock to stock, etc etc etc.
Thats the basics... it can and does get much more complicated than that though, but for the purposes of this conversation, it'll do
Hope that makes sense