I've had them all over the years (magnaflow, borla, corsa) and it really comes down to personal taste. Corsa is going on my C7 shortly, magnapacks I have on my roush, and my sierra has borla ATAK on it.
You have the sound figured out correctly, it goes (quietest to loudest) Tour - S Type - ATAK; from your post ATAK is not for you. I like it loud, but from how you talk I would say touring or S-type is more for you. S-type is not that bad unless you really get on it, then its definitely significantly louder than touring muffler.
It is true borla do have some drone, BUT this is significantly reduced when you purchase an authentic catback, which makes a huge difference in drone experienced. I do not have a C6 anymore so I cannot comment on your specific car, but the actual system does help with drone where a lot of people just throw the mufflers in which will lead to drone. It does pick up as your pickup speed, but it varies car to car and peoples tolerances. Like I said I have the ATAK mufflers on my truck, and I love it loud, and my wife drives it and does not bother her at all.
Lastly, the sound you are after. Corsa vs borla is much different. Exotic vs. muscle. Personally I prefer magnaflow over borla, but corsa is distinct in its own right. I prefer the sound of muscle on the mustang and the truck, but the C7 I love the corsa sound.
You really cannot go wrong with any of the choices, comes down to your preference for sound, decibel and budget