One of the loudest exhausts commonly encountered is unaffectionately referred to as a “fart can”

It’s nice in the way dog shit brown is a nice color

In that technically it is opinion that that defines if it’s nice, and if you ask enough people you’ll find some who like it, but most people (including car people) do not find it nice and insult their owners.

If anything car enthusiasts trying to get a better sound go to great lengths to cut some of the loudest resonant frequencies an engine produces (referred to as drone)

-

My car is not exceptionally loud and won’t wake up even a suburban neighbor (I live in a city now so it’s parked in an underground garage). If I take it to a race track and wring it by it’s neck, shifting as close to redline as possible, it’s certainly not as quiet but not many cars are in that setting...

The Koenigsegg would probably not be loud puttering around, these cars are designed for refinement. If it’s waking up a neighborhood, it’s because the driver is treating said neighborhood as a raceway, and at that point sound is very low on the consequences that can have.