I kinda like Goethe on this, when he speaks about the eternal feminine which was at the center of his metaphysics. Whereas the feminine is not something primarily sexual, it's more the promise of synthesis and the allure of the mystery of higher unity, beyond rationality and brute will.
While sexuality is part of nature’s law (Naturtrieb in german) and thus neither shameful nor supreme. overindulgence or oversexualization, was always a destructive force for him, dragging you downward, toward base compulsion rather than upward, toward the integration of body and spirit. This modern environment of hypersexualization, where the feminine is reduced to commodified surfaces, it takes from us the mystery, the wholeness and our own meditation between the human and the divine, this transcendental dimension just collapes into the marketplace and it chains you to your base appetites.
Raw desire and obsession will lead to ruin, like so beautifully portrayed in Faust and Werther. There is nothing wrong with desire, but it is not supposed to be your ultimate truth. The divine feminine is the antidote, it elevates the eros into something generative ennobling and in the end reconciling.