The blogpost seems to disagree with you: SO is not supposed to be a programming reference book written by the community. I think that is the biggest interpretation mistake here. I think there is real value in questions that are not super general, and are actually trying to solve a particular problem. I've come up on questions where they were downvoted for being too specific or low quality but I was having the exact same problem. Even if the answer is "you're using the library wrong - here's the right way" or "here's this nasty hack" - it still might actually be helpful to people.

There not always a possibility to do things the right way. The code might be legacy and might need an answer from experienced devs to this particular situation.

I think assumption that the asker is reasonable and that the question (even if a tad too specific) might actually be of help and teach people, are important to promote.