I think it really depends on what type of foundation you use: mineral, cream, liquid, etc.
Right now I'm using the Everyday Minerals Foundation Brush with liquid foundation. It works pretty well. It's super soft and doesn't leave my face with streak marks. But I'm going to purchase the EM Stippling Brush when it debuts at the end of this month. I've heard that stippling brushes are excellent with liquid foundation.
Yes, I use a stippling brush with my High Definition Make Up Forever liquid foundation. I had never used one until a MA at Sephora showed me.