Part of your question addresses the DRY precept. The development of a good answer represents an investment of time, and it would be a good return on that investment if the answer could be shared among many questioners who have related questions, without much added investment on your part. I'm talking "return on investment" in the sense of knowledge sharing here, not rep gaming or self promotion. Not to disparage either of those two, but I'm only discussing one aspect of goodness.
The DRY precept surfaces in different ways at different levels of abstraction. At the level of data definition and database building, DRY surfaces as data normalization. At the level of OOP and data sharing among objects, DRY surfaces as classes that extend other classes. And so on.
The problem that is vexing you is, in part, a problem with the SO community and the SO infrastructure as it relates to DRY at the level of sharing skills and knowledge. For every class of questions, there is a "canonical answer" that would serve to answer not only the question at hand, but also future questions in the same class. In the best of all possible worlds, some of those future questions never have to be asked, because the would be questioner is guided to an existing question, and is able to get the needed answer from one of the responses.
Some questioners have the insight to be able to read a specific answer to a specific question, and (sort of) infer the canonical answer from the specific answer, and then apply the canonical answer to their own question. Other users have to be led by the hand to specific answer to their specific question. Most of us have this ability to a greater degree in some areas of computing, and to a lesser degree in other areas.
"Please give me th codez" is perhaps the ultimate in asking to be led by the hand. The other extreme is a formal course of learning, where the concepts are featured prominently, and are of very wide applicability. The examples are meant to flesh out the concepts, and to give the learner some practice at applying these concepts to specific cases. Homework problems provide further exercise at applying the recently learned concepts.
The amount of investment in developing a good formal course of learning is immense, and dwarfs the investment in coming up with a good answer in SO. The amount of investment in taking a good formal course of learning is also very large, and dwarfs the investment in asking a good question in SO, and getting some good answers quickly.
A good formal course of learning also uses the DRY precept, but at a different level of abstraction altogether.