Wikipedia has a list of people excommunicated by the Catholic Church, with a little explanation of the causes for each case, but (understandably) none of the effects.
I'm curious if this measure has caused the downfall of any ruler, specially in the Middle Ages, when the power and influence of the Catholic Church was most strong.