I had a Catholic upbringing of the strict variety. If you are a naturally a thinker/worrier it can get your head tied up in all kinds of ways because it's basically 2000 years of people saying all kinds of completely different stuff then doing mental gymnastics to find a way to argue that it fits together.
i.e.: St. A says everyone goes to heaven and is a brilliant theologian. St. B says that almost no one goes to heaven and is a brilliant theologian. Pope says story X is basically just made up and believing in evolution is common sense. Pope says story X is totally legit and it's unnatural to be gay.
That said, there's a lot of good I've gotten out of it; the "examined life," not judging, and even the guilt stuff has probably been pretty good for me in curbing some of my less empathetic traits.
Now my religious outlook is most similar to the desert monks in the first millennium who focused on stuff like having faith but not fronting like you understand shit, not judging, loving your neighbor, praying and checking out as much as possible from the rat race. I'm also the kind of insufferable fruit cake who gets an 8 petaled flower tattoo to help remind himself of the 8-fold path as i did last week. And while I embrace a "theistic" faith, I would also consider myself a humanist.
I do think religion and raising kids presents dilemmas. Being Catholic for me is sort of like being Jewish where it's a cultural thing too. My approach is we go to Church, but I also break down my disagreements to my kids (e.g. gay marriage is cool, women should be able to run thangz too, there's no way it was good for the ancient Israelites to sacrifice animals and kill off entire neighboring tribes except for the rapable young women, etc. etc. etc.) I'll give money to things I agree with, like rebuilding places after disasters, but not other stuff.
Sorry for the novel guys.