Having owned diesels for the best part of 8 years now, I can offer the following:
8 years ago, there was a positive swing to diesel if you were driving anything over 20k per year. Fuel was cheaper, more reliable, albeit noisy engines were cheaper to maintain but still not without their issues.
Big engined diesel cars do not like being driven around town, period. They like sitting on the motorway in 6th gear at 1500rpm. That's when they behave themselves. Barely ticking over reduces a lot of the modern concerns from modern diesels. However, for them to be cost effective in current times, you need to be ploughing at least 25 -30k miles a year.
Doing exactly as above, sitting on a motorway at 70mph, bored, I achieve around 47mpg from my 530d over a 200 mile journey, all motorway. I pull out around 700 miles to a tank between fills like this, and the car gives me little to worry about (although it is under warranty).
I like the way diesels drive, especially on the motorway. Effortless overtaking if needed, sometimes verging on the surprising at it's ability to get past things that seem very very far away (if on A roads). However, a lot of modern turbo petrol units will do this too.
Would I buy another diesel? Only if the mileage was a concern. Even doing 400 miles a week, I don't deem it necessary for a diesel. I absolutely want to go back to a petrol, however, market forces, and the buying nature of the general public means my chances of getting a petrol car in the spec, colour, trim level I want, are virtually impossible. The difference in tax and efficiency between a modern petrol and diesel is marginal.