There is no such thing as good back pressure. That is a never dying fallacy. An engine is an air pump. Anything that makes it less efficient is bad.
The important tuning part is exhaust pulses, and there are many variables to that- pipe diameter, length, transitions, bends, collectors, cats, etc.
Once the cat is removed, you may need to tweak the tune a bit, but the end result would be more power and better gas mileage. Along with a little less weight, a little less heat, a little more sound. Possibly not the sound you want. On cars pulling cats can make it 'raspy' if no resonators are in the system.