The terrible smells is the worst when the AC is turned off and then on with a 5-30 minute time gap. I find that even when the AC stinks, as long as I turn off the AC and dry the coils before I shut the car off, the next restart will have almost zero smells. That 5-30 min restart is to key to making it stink.
Ranking all the different types of foams and cleaners I've tried so far:
#1. Klima cleaner (smells clean, worked, not the cheapest)
#2. Frost King 19oz AC foam coil cleaner (giant can, really fills up the whole coil and then some, doesn't smell bad but also not amazing)
#3. Interdynamics AC cleaner with a straight spray nozzle extension (smells artificial and didn't work too well)
#4. Kool it (way too tiny of a can, overpriced, smells good though, but doesn't have enough coverage to ensure 100% cleaning)
#5. Microban spray into the filter area/intake (didn't do anything to kill the bad smells)
New filters can help, but I'm about 90% certain that it's not the source of the smell. I've taken out old filters and made them wet, and they didn't smell sour or anything like the AC's old feet stink in any way.
My AC is stinking again about 4 months after the last cleaning, tried kool it and it smelled good for 2 days before the stink came roaring back after a 20 min stop between AC usage, yikes.
I'm gonna try other products and see if they'd be a more permanent solution to this problem.