Since the Catholic church self describes as “Apostolic”, “Holy”, I should think Catholics would ask at what point God would say, “Enough! I’m done with you”.
The same can be said of Christianity as a whole. If you have not noticed, sin is a permanent part of the human condition. I dare say it is also so in your denomination.
As for at what point God would say, "Enough! I'm done with you", I remind you of St. Paul:
For Christ, while we were still helpless, yet died at the appointed time for the ungodly. Indeed, only with difficulty does one die for a just person, though perhaps for a good person one might even find courage to die. But God proves his love for us in that while we were still sinners Christ died for us.But I will point out what you wrote above that: "Over the past thousand years many attempts have been made to “clean up” priestly morals." Thus by your own admission the Church has been fighting, however unsuccessfully, against immorality within its ranks. Any suggestions that the Church actually approves of these actions should be fully rejected.
(Rom. 5:6-5)
But I would offer the ancient nation of Israel as an example.
It had traditions, sacred writings, holy men, a priesthood,...and a history of moral failure, sometimes opposed by the king, more often led by him.
Failure, repentance, chastisement followed by forgiveness and relapse in a rather predictable pattern.
Until Jesus says, “Your house is abandoned to you” and “The kingdom will be taken away you and given to a nation bearing it's fruits”.
Israel's favored position like a son, promises made to Abraham, etc. did not prevent judgment from being executed upon them.
So it wasn't a case of individual sins which a sacrifice at the temple and then Christ's sacrifice would cover but whether the individual would be part of a nation approved by God or not. Those that didn't want to suffer the fate of Jerusalem had to leave her.