OTOH questions like I am trying to do this very specific thing that interacts with multitudes of other systems and cannot get it to work are therefore not considered StackOverflow worthy.
If it is completely unique and is of no use to anyone else, then it still of use to one person and still worth answering. Maybe SO just needs a flag for questions as 'unique situation' so it doesn't appear by default in future searches.
Also, SO isn't really a wiki. It's not designed that way. It's built around "this is my problem; what is the best solution?" interactions.
or homework questions
But for every response of, "What code have YOU tried?", there's someone who posts the answer to the question, and the user gets their one-time answer and never comes back
Remember JavaScript.com? SO is that but for every language and with snippets of code that have been validated by names that are so well recognized for being brilliant that would I start to mention one then I would have to name everyone and they are too many. So we shouldn't frown upon people who take those snippets of code to try to make a buck. Is all I'm saying.