16% of personal vehicles in the Netherlands are currently diesel cars. About 20% of all vehicles sold here last year were diesel vehicles. So at least here, it's very common for people to drive a diesel car. They come in all sizes.
But yes "clean diesel" took off on the EU (somewhat) but in the US diesel means dirty smelly trucks/buses
So all in all, a modern diesel is pretty clean. Not as good as a modern gasoline car, but still reasonably ok and massively better than old diesels.
There is nothing inherently requiring diesel cars to be slow.