If you're just after aesthetics then the tips will suit you fine, but on their own they will make no difference to the sound.
If you remove the backboxes and replace them with straight pipes (with tips on) it will alter the sound as well. Not as much as if you also removed the CAT and/or DPF, but it will have an effect. I can't say how much, as I haven't done it, but I'm sure others have trod the same path previously and can comment.
Don't base your decision on a de-boxed 2.0tdi, the 3.0tdi sounds much more refined and less like a DERV!