What I have found that works the best is to keep it as simple as possible. The next person that does our job may not understand what we have developed and would have trouble maintaining it. For this reason, I find that the best solution is generally the simple, straight forward solution. Sometimes this is not the best or the most elegant solution but it works and is the most maintainable.