Definitely approve that failure must be meaningful. And the idea of allowing a single skill check on some problems is a must!
However, I did not mean to say that I made Failing Forward the rule of law. Sometimes it happens, I might have a counter on my desk to make sure that I don’t use it too often. Sparingly is good.
But some situations are pretty straight forward, the players have the blinders on and hey want to do this or that! So, the best solution is to be flexible. Perhaps put them in trouble for it, now or later, to make sure that they have their fun. It can be pretty fun for you, too, as the GM. Mwuahaha!
The reason why I use the rules I presented is because they help me out with inspiration: it helps me make the story and the scenario as things happen. That’s why I love them so much!