It is an issue because, as much as we like to hold ourselves as the True Church, we also have to admit that we have our own problems, they just don't make the news as much.
Before I talk about anything else, I must say this: if you do not hold yourself in communion with your church and its beliefs, you should not take the eucharist. Doing so is harmful for yourself because its a false affirmation. If you do not have faith in your church, then you would only hurt yourself by doing so.
I feel its a little easier to talk about this as an Orthodox because there are multiple jurisdictions that all share the same faith, but are separate in terms of temporal affairs. That means that I can shake my head in sorrow at the Greek Orthodox Church's issues, but also be sure that my tithing does not go to them. However, the Church is not just the clerics, but also the laity. The community at my church is important to me, which colors my thinking.
One thing that might give you some context or comfort is that this is not a new phenomenon. St John Chrysostom, one of the greatest preachers of the church's history in the 5th century AD gave us this quote I paraphrase,"The road to hell is paved with the skulls of errant priests with bishops as their signposts." The Catholic Church is on fire right now, but I think it has always been on fire.
My thought process might be different than yours, I do not know how Catholic priests handle such things, but my spiritual Father has a duty to explain himself to me so that not in blind obedience, but in joyful acceptance I walk the Path. My answer ultimately for attending and supporting the church, even in the scandals its had, is that I can't do anything else. I believe everything in the Nicaean Creed, I believe in Jesus, I believe in his one united, catholic, apostolic church. Obviously I'd do the best I could to make sure that the bad shepherds can't harm any more people, that my tithing goes only to things I feel are good, but in the end it comes down to that I can't find a better alternative to being in my church, to the everyday salvation I experience. I can only pray that you can resolve this conflict within yourself, because all I can tell you is we absolutely as the laity should ensure that our faith is maintained in the correct ways, yet even when it fails I just can't do anything else but carry on.