I know how you feel OP.
I was brought up CofE, went through an evangelical stage in my teens (and was a bit of an arse about it), spent a few years as an agnostic, then got into paganism, which I found very enriching but ultimately nice fairy stories. I'm now an atheist but still enjoy a bit of paganism or the occasional church service in a cultural way.
Religion IMO has been a tremendous force for both good and bad in the world. I know people who have been very badly harmed by their experiences with religious organisations of several faiths and denominations. I also know lots of people of faith(s) who do a huge amount for others. I'll never forget the kindness and support our family received from the CofE my mum attends when my dad died, and they continue to support her now she is elderly and less mobile in all sorts of small, everyday ways. Also a lot of the food banks are run by churches and when I have clients who have literally nowhere to sleep that night and the council won't help, it's churches who give them shelter.
I've got friends and colleagues of all faiths and none and the subject rarely comes up. I think for deep friendships though, religion can create barriers, just as politics can.
I'm not a scientist but I do like to discuss things from a basis of rationality and, if a friend believes in god (or anything else for which there is no evidence) it means there are certain no-go areas for conversations, partly because I don't want to offend them - it's a contentious topic, as evidenced by this thread, but more importantly because we are approaching a topic from completely different starting points. Faith, by its nature, has nothing to do with evidence. If there was evidence for god, nobody would need faith, or to believe. So, while I have nothing against people of faith (and have been one myself in the past), certain converstations inevitably become frustrating.
There's a great book by Daniel Dennett - Breaking the Spell: Religion as a Natural Phenomenon which looks at the role religion has played in human evolution. It does appear that religion has in the past been a pretty much universal phenomenon and has had an enormous role in the development of human cultures.
I'm a couple of pages behind but I noticed some discussion about whether everybody's views should be respected. I don't think they should. Some people's views are abhorrent, others just don't stand up to scrutiny. Maybe someone has linked to this already but there's a great article here: No, you’re not entitled to your opinion. The author argues that you are not entitled to your opinion, you are only entitled to what you can argue for (and he argues it well
).