No, it is different.
Formentor has a valve in the exhaust. In Comfort mode, the exhaust flap/valve is closed and (my guess) engine mapping doesn't produce pops and bangs. When you switch the mode to sport or
cupra, you can hear an flap/valve open if you are outside the car, you can see that "smoke" comes out of all 4 exhausts now and in this mode you hear the pops and bangs. In some situations, car does not open the valves until it is warm.
You can drive all day long in Comfort mode without pops and bangs.
This existence of a valve/flap is not well known, most reviewers of the car did not know about it, but it is definitely there. I remember there is a video where a guy is in a cold garage and he shows how when in comfort, the smoke is coming out of only 2 exhausts and when you switch over to sport/
cupra all 4 exhaust pipes are "smoking" (I know it is water vapour).
The soundaktor only helps with the sound inside the car. To be fair, the car does not sound very good from the inside. I completely understand why they did it, even though I don't like the concept.