My mum owns a 307 HDI and my brother a Golf TDI. The Golf sounds fine, a little rough at first. The 307 sounds rough as hell though, worst diesel i've ever driven imo.
Pug used to make some good(ish) diesels, if they are worse than the VAG ones now then they must have really lost the plot