Yes. I think it violates the goodness of creation.
In my previous post I was quoting from secondary literature. For this response I’ve taken a look at the most relevant sections of the City of God.
First, it has to be said that Augustine acknowledged that prior to the fall, sex was good. It was, in his view, a purely rational act intended to create children, with our sexual members being moved just as we move an arm or a leg. However the fall corrupted our nature, sex with it. He seems bothered that the movements of sexual organs aren’t rationally controlled but respond to our emotional state. This is true even in sex between married couples, so even there he considers it lust, and even when properly used he considers the sexual parts of our body shameful.
Here’s his description of how it would have been without the fall: “Far be it from us to imagine that, in the midst of such material ease and such human happiness, the seed of offspring could not have been sown without the disease of lust. Rather, the sexual members would have been moved at the will’s command, as the other members are; and, without the enticing goad of sexual heat, the husband would have poured his seed into his wife’s womb with tranquility of mind and with no corruption of her bodily integrity.” … “the male seed could have been discharged into the wife’s womb without harm to the woman’s genital integrity, just as the flow of menstrual blood can now be discharged from a virgin’s womb without any such harm.”
It should not be surprising that given such a view, he prefers virginity, although clearly a married person with faith is preferred to a virgin without. In giving an allegorical interpretation of Gen 6:16, he notes that "Again, and far more suitably, the three stories could be the three abundant harvests of the Gospel— thirtyfold, sixtyfold, and a hundredfold; and in this case marital chastity would occupy the bottom story, the chastity of widowhood the story above, and virginity the highest story.”
I don’t think there’s any Biblical reason to believe that the fall reversed the goodness of creation to the extent that it made parts of our body inherently lustful, even when used properly. Furthermore, I would consider the emotional side of our nature good. It's an inherent part of how we're built. (Augustine probably didn't know that, however, since in his time details of the brain and nervous system weren't known.) God is described in the Bible as having emotional reactions to people and events. Christ wept and got angry. I think his views are a violation of God calling creation good, and that it leads to a serious misreading of the Biblical criticisms of lust, since it transforms them into criticisms of sex itself rather than its misuse.