Just to add my two pence worth:
In simplistic terms, with a smaller diameter zorst pipe, top-end outputs will be resticted, but low-range torque will be increased or enhanced. At the other extreme, a large diameter pipe will have the opposite effect - much better at the top end, but also noticeably worse torque at the bottom end (and also mid-range on a normally aspirated car too).
The 'happy medium' will be to find an exhaust diameter which maintains a decent low- to mid-range torque, whilst not overly limiting top-end power.
Standard discaimers also apply - in that there may be other limiting factors too. If you bolt on a 6" dia zorst, on sommat with a teeny weeny turbo - not only will you look like a chav, but it wont give you any of the 'expected' increases top-end.
And back-pressure - virtually all engines, including our beloved GTI mota, all need some back-pressure - for very teccy/nerdy reasons.