Your note about the Tiguan makes me sad. I'm moving back to the US next week and was seriously thinking about getting a Tiguan (and hoping for a diesel). I'll add the Sportwagen TDI to my list.
Wagen is a great vehicle. I love mine.
Complex solution: Chip the engine - some people prefer a smoother power curve, which can be achieved with a tune.
I imagine that yes, being able to keep it in low gears would have helped, and indeed putting it into manual mode for some of the parts I found the worst (rapid turns from one busy street to another) helped, but it put it in the "More trouble than it was worth" category.
That being said, the TDI was a great car, and a serious contender for my money. I just preferred the GTI a bit more, but given I love the GTI, that's good company to be in.
It's geared lower, for one thing, only 2000rpm at 75mph.
FWIW, I traded in a 2012 TDI with the DSG for a manual Mk7 a few days ago. Love the stick, although it's taking some getting used to (this is my first manual).
Also in the manual's favor is the $1,100 cheaper upfront cost and not needing a ~$400 transmission service every 40k.
The fantastic fuel economy was the icing on the cake.
The GTI gets rid of one of those problems, and is a spectacular car in its own right.
One of the problems is that VW that they add premium options to the TDI marque. So you can't get a bare bones Jetta TDI without the highest trim level, fancy wheels, and other things that add to the cost. On top of that the gasoline ones are efficient enough where the price difference becomes a non-factor, even when taking the MPG into account.
They are damn fun to drive though, torquey without the compromises of a 4 cylinder gasoline engine. The used market on the sportwagens is great too, which is why we ultimately traded it in for a Tiguan since the demand for the wagens was high enough to make that a relatively easy financial decision.
Unfortunately VW doesn't do diesel Tiguans in the US, which is weird, you'd think the SUV market would be a no-brainer for TDI.