On average, I would venture that most contemporary philosophers acknowledge the detrimental effect that organized Western religion had on humanity. But trying to seriously assess whether it's been positive or negative to any discernible degree is pretty impossible; after all, the criteria for such a judgment can't really be settled. Sure, it may have caused immense physical trauma and fatalities (Crusades, Inquisition, etc.); but it also certainly provided a central force of direction and consolation for people. I, for one, would weigh the material consequences (i.e. physical pain and suffering) above the psychological (i.e. personal), but it would be presumptuous of me to try and institute that. Who am I to say that the death of a husband in the Crusades qualitatively outweighs his family's psychological well-being due to their belief in God (if they attribute it to that)?