As you can see from reading these threads, sound is mostly subjective. Drone to some is music to others. If you do a muffler delete, drone is a given. Muffler replace and resonator delete, drone is highly likely. Muffler replace and leave resonators, drone unlikely. Full catback, drone depends on the manufacturer and aggressiveness. The more aggressive and loud, the more drone you will hear.
I think you are also talking two issues: drone and the sound some hear when MDS kicks in which is caused by air being forced through the weep holes of the resonators, which I personally view as totally separate. For instance, if you have straight thru pipes you will have drone on any vehicle, with or without MDS. So I view drone as the frequency (constant rumble) you will hear inside and outside the cabin. Mufflers and moreso resonators, will attempt to remove those low frequencies.
If you just do a muffler replace you will be safe from drone. If you are going to do a full catback you will have to pay attention to how aggressive the setup is. Read about them on here and try to find sound clips and reviews.