Why hasn't chemistry brought about a greater level of human enhancement(as of yet)?
This is not a limitation related to chemistry, but related to the lack of understanding of the human body and mind.
There are a couple exceptions, such as the Cochlear implant (wich basically transforms a deaf person into a hearing cyborg), pacemakers, and some drugs that can enhance mental capabiliyties.