*** UPDATE ***
I ended up using an OEM refresh kit to get the mildew smell out of my air system. But in the process I decided to first pull the console kick panel below the glove box so I could watch and make sure nothing was oozing out during the foaming process. And in doing so, I noticed something I haven't seen discussed on the forum before: That being the cabin portion of the drain hose pathway. When the kick plate is is removed it exposes the right side of the evaporator chamber casing so you can see how/where the drain line connects. From looking at the many twists and turns (especially the final 90 degree right angle turn) that the drain line makes, it seems it would be difficult to get any kind of conventional DIY roto-tool into the drain line from below to properly clean it out or fully remove an obstruction. I suspect clogs are mostly going to be right at the exit of the pan where it makes the first 90 degree turn. I am guessing the best way to clean this out would be to first try and use a very thin, semi-rigid piece of plastic or metal string/wire from under the car to try and open up any potential clog. Once any trapped water finishes dripping then pull the hose right off the evaporator chamber inside and clean out the both sides of that connection, possibly also use a syringe to squirt a cleaning agent into the drain line so it runs out under the car. Or if you have a compressor can try to blow it out as well. And then use a bottle brush of some sort to make sure the entry portal into the evaporator chamber is cleared.
I wasn't brave enough to pull the drain hose off the evaporator chamber, maybe somebody else wants to be the guinea pig. lol Also, I noticed just North of where the hose connects there is some kind of thumb-screw with a wire going through it as well. Looked like it may have a rubber gasket casing as well. If this is removable it may allow a direct pathway to spray cleaner onto the evaporator, which would be a much easier way to spray cleaners on the coil if needed to combat mold/mildew buildup in the coil and pan. Again though, I was too chicken to experiment and remove the thumb screw so cannot say for sure.
BTW, the kick panel can be removed by pulling on it at the seam nearest the seat (two clips) and then once that front portion is free slide back so the front is released.
Sonic