While 6th note of Dorian and 4th note of Mixo has special reasons in their avoid note (refer to my workbook page 12), generally avoid note is a note that produces b9th interval against the chord of the moment (this includes anticipation in jazz style). The effect of b9th interval is that it destroys the tonality. As soon as you hear this interval, you looses the sense of unity. This is in human nature. Of course, knowing this, you can intentionally create b9th interval for your creativity. John Scofield does it all the time. The important point of this is you must know what you are doing.
Here is the rule of avoid note you want to repeat until you have it in your body:
There is one more rule. Read on…