Diesel Sounding Awful

Now maybe it's an obvious statement but it's not all of Diesel cars that I'm having a go at, but some and the Mondeo I drive at the moment is one of these, they sound awful. Now some such as an old Passat have a fairly nice sound with a sometime turbo whistle, while this Ford has nothing nice about the noise at all.

Why is this? And is there a reason for it? 

I've had in recent years a 530d and this sounded ok, i've driven lorries usually of 500hp or more and these sound nice, i've had a Discovery with the V6 Diesel and that was nice sounding but why is it that the more run of the mill cars in the car industry seems to be missing out on using some of there budget to make a diesel sound nice. Maybe a V8 rumble or at the very least a turbo whistle to drown out the awful diesel noise. 

Can't be the only person to have thought this ? Am i ?