Eh, "car go wroom" is something that many drivers find rather enjoyable, me included, but just like with everything in life there are some people who go way overboard with it. It's just that with cars, overboard is also by far the simplest and cheapest way - you do straight pipes, which is exactly what it sounds like, just a direct pipe with absolutely no design or mufflers of any kind. They are ear shatteringly loud.
And for those, you do have the correct reaction.

While this is true, diesels often come from the factory with a conservative one size fits all engine tune.

You can usually make the car more fuel efficient and/or add a bit more power if you do it properly. Potentially you can even make it more reliable. One of the things manufacturers caught up in dieselgate did, is recall cars and give the engine a less polluting engine tune.

Obviously, that's not what most people do. They tune it to have as much power as possible (or if they're idiots roal coal) and are then surprised when the transmission or engine gives out prematurely, and the manufacturer no longer feels the need to honour the warranty.

You know how people say that a new car loses depreciates up to 20% just driving it off the car lot? Stuff like engine tuning is one of the reasons that difference exists. You don't know if the previous owner did stupid shit to the car.