It is loud that people will notice. It is not really possible to drive it quietly unless you are off the throttle, accelerate and people will notice you and likely turn their head. The noise is an aggressive deep tone, but honestly really good in my opinion. Full throttle pulls are amazingly aggressive but with a solid tone, not just loud. This is my favorite part. There is just something to it that is spot on. V4 drone is there bit minimal. In the cabin windows up with music at low-mid listening volume it is noticeable but not distracting during city driving. Conversations are had without issues.
My wife who rolls her eyes at car things I do and buy actually really likes the tone of it. She said it's very aggressive sounding, not too little and not too much.
I've got loud borlas on my corvette which is matted to a 350 HO deluxe crate engine. Those are very loud but lack the distinct tone that these stypes have. Sure my corvette has the awesome lumpy muscle car idle, but there is something to the actual notes of the stype that is great. More refined for sure, but still plenty of in your face. My corvette for comparison is very difficult to have a conversation in the car with that exhaust. You have to talk very loud almost yelling.
Honestly, I never heard the corsa or borla stype in person before buying so I suppose it is possible the corsa is even better. YouTube videos certainly don't do the proper justice. Best course if possible is to hear them in person.
Really though, my gut says you can't go wrong with either one.