First off, I'm not sure there are as many of those as you're implying. I think a pretty fair number are looking for "I get what I want to achieve or I have to find another way." The automatic assumption that failure will translate into additional problems is not something I think that many people are wanting.
But the issue with PbtA is that even when you do get what you want, it often means that something complicating happens. In practice, to many people that means you've made bad results more likely and just thrown them a bone.
Again, if you don't understand why that's an issue for many people, to be blunt I think you're part of the group I was talking about that just doesn't get it.
I largely agree, but the chances involved also matter here. Outside of your area of specialties in the two PbtA games I own, "failure" and "success with consequences" are the biggest part of the probability space.
I’m talking D20 fail forward play here, which stresses evolving the situation on a failure. This is everywhere in 5e GM advice these days, including all the popular “content creators” and such. I’m pretty comfortable saying it’s mainstream.