These are all very rare exceptions. In general, God does not allow His Church to operate in such a haphazard way.
Regarding the rarity or commonality of such occurrences, neither of us are in position to opine.
What I will say, is that the Church teaches us that we can acquire a moral certitude regarding validity, so long as external intention is manifested (i.e., the priest performs the rite), even if this does not infallibly exclude invalidation by the same minister covertly forming an intention not to do what the Church does.
As l' Abbe Hunter recounts (from p.1 of this thread):
"It is objected to this doctrine that it makes the validity of every Sacrament depend upon a purely internal fact, namely, the intention of the minister who may perform the outward acts with the interior intention of not acting as deputy of Christ. We admit the consequence, but deny that there is anything in it out of harmony with other parts of revealed doctrine; it is perfectly true that, without special revelation, no one can have absolute certainty that he has received a Sacrament or that he is in the state of grace (n. 639): but his assurance on the subject may approach so nearly to this absolute certainty as to make any misgiving on the subject foolish and vain; and it must always be remembered that God, who has bound Himself to give grace when the Sacraments are duly received, has nowhere limited His power, disabling Himself from giving grace apart from these holy rites. One, therefore, who acts in good faith may hope that no disaster will befall himself or those dear to him through the deceit of a wicked minister. (See n. 696.)"