What Cab says, plus:
The shape of the car can matter; had a wagon that I tried 3 sets of mufflers just looking for the right sound and livable loudness.
My muffler shop guy still laughs about that episode.
I've had 2 Dusters that came with Flowmaster 40s that sounded crisp & had a nice bass tone, not tinny; had to add tailpipes to one to quiet one car.
Neither had any drone to speak of, contrary to common experience.
Also there seems to be some difference in the engine's power: a strong 383 sounds different than an average one with the same muffler.
Size as well: my 368" drag car with Race Bullets is a bit quieter than the same system with 448".
I've done 3" with 2.5" tailpipes and it quieted the car; no apparent butt-dyno difference but no ETs to report.
I tend toward the Dynomax SuperTurbos, which also sound different on different cars.
The RR/GTX/etc tips seem to accentuate the exhaust pulses with a crisper tone.
I'm strongly tempted to try their UltraFlows on the current 383 RR; it has SuperTurbos and they're surprisingly quiet all the time.
Unfortunately that video doesn't really tell much about tone when driving.