In my experience, U.S. Catholics are decidedly (and ironically) parochial. The bishop is regarded as an administrative adversary from the big city who has little idea of the daily goings on in one's local parish. I can remember several times growing up in which some decree from the bishop was very much at odds with how the local parishoners viewed things. We had no idea what cardinals were for, but we usually liked the pope 'cause he was the one Catholic who the media paid any attention to.
Re: pedophile priests, and why they're tolerated by rank and file Catholics: It's complicated, but I think it stems from stuff like this:
1) First, Catholics who've given any serious thought to the situation at all have already left the church.
2) Those that have chosen to stay in 2012 are already rationalizing transubstantiation, resurrection, and virgin birth - the "overall good of the Church outweighs the harm of a few bad apples" rationalization is a walk in the park, comparatively.
3) Suffering - the more one suffers the more likely one is to get to heaven. This is straight out of the Sermon on the Mount. So while personal tragedy might make Catholics sad, they don't necessarily get outraged the way other folks might expect. (One of my main motivations for finally breaking away was that I wasn't feeling outraged enough by tragedies in this world. Once you realize there's no heaven waiting for these miserable, suffering people, you care more about doing something to help them right now.)
4) Forgiveness - In Catholicism, suffering is a blessing and its corollary is forgiveness. We forgive no matter how heinous the crime. Remember, Jesus asked forgiveness for the guys who were at that moment crucifying him.
5) Gay people - Catholics know darn well that some people are just gay and there's no way around it. They don't "choose the gay lifestyle" or however some idiot mouthpiece like Santorum might characterize it, people are born gay and rank-and-file Catholics have recognized this for centuries. In olden times, there were no opportunities for these people - except in the Church. So it is assumed that some significant proportion of priests are gay and sadly, "gay = pedophile" to Catholics - or at least gay "celibate" priests are likely to be interested in fondling altar boys if the opportunity arises. So we were warned to "not get too chummy" with the priests and that was that.
I realize that some of these thoughts might incense some readers; I'm just trying to paint an honest picture of how Catholics in my experience might react to these ideas. I have no doubt that millions of people in the U.S. right now would agree wholeheartedly with 2–5, and that these attitudes are in large part responsible for the absence of outrage among Catholics re: pedophile priests. Keeping such scandals hush-hush isn't really that far out of step with core Catholic values even though it seems a direct contradiction to what the Church is supposed to be about.