Getting a 3” to be reasonably quiet is not too difficult. Getting it to be quiet, while not being droney is the harder job.
Getting it quiet, not droney AND not restrictive is a challenge that is beyond the skills of many exhaust shops.
Broadly speaking, dropping the rear muffler down to 2.5” will make it easier to keep the drone away usually with less restriction than a drone-free 3” system.
For outright performance that isn’t just deafening, you want a full 3” system with a long resonator/hotdog, and then a big straight through 3” muffler at the back. It will drone.
If you start adding more mufflers and/or chambered mufflers to quieten it down/beat the drone, you will begin to restrict the exhaust - whether this hurts performance depends on how much power it is making and how much effort you put into muffler choice.
Talk to the exhaust shop and pay careful attention to how they respond. A confident “Yes, we will do x, y, z” is generally a good sign.
But if they say “yeah, yeah, it will be fine”, then ask more questions.