Oof, my experience is the exact opposite. I was raised Catholic, and my family attended mass every week. I realized I didn't believe in god in my early teens. For many years after that I really wished I could believe, tried to believe. My parents had me enrolled in CCD (for those of you not Catholic, that's basically the Catholic version of what's colloquially known as "Sunday School") through 8th grade. I participated in some of my church's youth groups, and was friends with quite a few religious people.

But it just didn't work. I wasn't a militant atheist; I just questioned things, and was frustrated when my elders would shut me down and hand-wave my questions away.

I gave up in my early 20s. That was 20+ years ago. I'm still an atheist. I don't have a problem with religious people, unless they try to force their beliefs on others (especially when they try to use the political and legal process to do so). But most folks seem to just want to live and let live. But I no longer think there's something wrong with me, or long to be "normal" like my peers and believe in a god. I can't imagine ever believing, regardless of what communities I find myself a member of.