Back pressure doesn't really apply with forced induction engines to the same extent. Because the intake charge is already above atmospheric pressure. Back pressure is all about exhaust scavenging on n/a engines, which is basically using the exhaust pulse from one cylinder to create low pressure to "draw" in air into one of the other cylinders. To get the timing of the pulse matched to the right valve opening is the science and art of exhaust tuning.
The "back pressure" bit is more about stock air/fuel ratios. As in, if you improve the exhaust breathing, often cars and especially carb ones, would then run like crap. Because they would need the fuelling adjusted too. But many people wouldn't do this and just claim they need more back pressure
In reality for a 4 stroke engine you want the minimal back pressure to give high velocity exhaust gases.
With a turbo diesel it is all about flow and lowing EGTs. The bigger the pipe and less restrictive the better. On some of the big US truck diesels, when tuned they run 5" or bigger down pipes, often retaining 4" piping all the way. Simply huge. No need on a Tdi though, they are low power and low tuning.
Straight thru would be no silencing at all. But when you have a turbo it does dampen the noise a bit anyway. The Tdi isn't really all that loud from the exhaust. Location of the exit and the body config will have more impact on noise.
My brother runs a side exit just behind the passenger door in front of the rear wheel. He has a cherry bomb style silencer fitted. It sounds nice, but is very noticeable in the cabin at speed or when on the throttle. More so than a stock rear exit setup, but it is not unbearable at all.
I run completely straight thru, but mine exits in the rear cross member. Mine is also a truck cap. I can hardly hear the exist from the drivers seat, although it is slightly more audible outside. But still isn't as loud as many other vehicles.
The worst thing you may encounter is droning. If you are unlucky and the frequency matches, when cruising you may get a lot of booming inside the vehicle.
Here are some examples to give you an idea.