My IG (I have a cold start idle video on the page if you're interested, still working on some actual drive videos that turn out ok)
I've had my S-Type kit on for about a week now. I like it a lot, and was a little worried about it and hesitated a while, but I have no regrets at this point and wish I had done it sooner.
The Borla kits have no drone to the exhaust unless someone just did the install completely wrong. On most any exhaust kit, as long as you have a resonator on, you normally won't get drone - that's one of the reasons the resonator is there. Some people will just remove the resonator and keep the stock exhaust otherwise, but I'm not much of a fan of it personally. The sound just gets too raspy and annoying. Drone comes from the resonate frequency (at whatever RPMs trigger it) matching the vibrations of the car and it causes the whole car to vibrate.
TL : DR Mansplaining Stuff:
The general rule of thumb in exhaust note mods is to start at the rear of the car, and work forward to get it to sound like what you want. Changing the mufflers alone (axle back vs cat back), then seeing what you get. If you still want it to sound deeper, increase the diameter of the pipe and/or change the resonator. If you want it to be louder, remove the resonator (this is where you reach the term "catback" as you are replacing everything behind the catalytic converters). If none of those change it enough, change the down pipe. If you still want it to be louder, change the headers/exhaust manifold.
Of course the pipe diameter will play a part in the tone being deep enough, but even in the Borla 2 1/4 inch pipe, the sound is actually pretty deep on it.
One thing worth mentioning - with turbo engines, in particular, if you go taking off exhaust parts, you will lower the back pressure generated by the exhaust system. This will lower the torque of the engine. I know people who have pulled off the resonator on their F150 or Explorer, and it noticeably lowered the torque, so they put them back on again.
If you want to know the science between the sounds, and why people prefer the V8 over the V6 sound, a V6 doesn't sound the same as a V8 because of the irregular intervals between firing on a 90 degree crank rotation. It fires two cylinders at a 90 degree angle on each side, which makes the "rumble-y sound" really noticeable. This alternating pulse and almost randomly perceived firing order is really the key to the sound.
A V6 doesn't do this since it uses 180 degree crank rotation to fire and the cylinders fire alternating left to right the whole way. This creates a more evenly metered cadence to the cylinders without the irregular accent tone that the V8 has.
When you get into V10 and V12, or W engines, you get more options because you're adding more cylinders. Some fire like the V6 crankshaft above, some don't, which is why they all sound different.
Hope this helps!