Hard to predict precisely. Far too many variables. It is generally true that the noisier a vehicle is and the less the manufacturer addressed noise issues, the bigger the improvement. Conversely, a luxury car will have very low noise levels to start with and most of the space we're counting on is already used.
I will guarantee that you your vehicle will not be silent. That's barely possible if you were designing the vehicle from scratch and there were no budgetary constraints. We have to work with the existing suspension, drive train and glass. Can't get to silence. It's a lot of steel, glass, rubber and composites rolling on a rough surface, propelled by exploding petroleum. You are going to put a lot of time and money into the project and somewhere along the line silence can become the target.
Just because it isn't silent doesn't mean it isn't drastically better. I consider a project a success if the vehicle is transformed from unpleasant to drive to pleasant to drive. That's a really big deal. If you can speak to a passenger without shouting, if your music sounds better and louder than ever before with the volume knob turned down from previous standard levels. If you can drive to work without getting a headache. All really big deals in my book.
The most interesting reactions by far are from people who parked their car and didn't drive it again until it was fully treated. It's harder to get the full impact when you've worked on the vehicle yourself since you adjust to the changing acoustics as you go. A really common reaction is for people to spend a lot of time listening to the sound of their own voices. They really can sound much different. It's also common to hear things that you couldn't hear before.
Reducing noise levels is always a good thing. What we are doing is re-engineering some luxury into the vehicle. There are all sorts of vehicles that have desirable characteristics - performance, economy, utility - but are just too noisy. Being able to influence noise levels with aftermarket treatments significantly lengthens the list of great vehicles.