I believe religion's a good thing - it's just the people that screw it up.
Seriously, my grandparents grew up in the same little country town in Queensland, Australia. The town (possibly 10,000 people?) was divided into atheists, Catholics and Protestants. Things were so bad that the kids from different sides would throw rocks at each other on the way to and from school.
Grandad was an atheist. Grandma was a Catholic. Despite strong opposition from all sides, they married. When they got back from eloping, Grandma was excommunicated and her family refused to acknowledge she was married, telling her she had to come home and stop 'living in sin'.

Eventually, the community got used to the idea, and even bought them a late wedding present.
Over the next fifty years, they raised two kids, worked extremely hard, bought several farms and retired to Brisbane to live near the growing extended family. They're still two of the most inspirational people I've ever met, but the experience has left scars - Grandma can still recite the nursery rhymes she and her friends used to taunt Protestant kids with, and Granded still rants about Catholic women having too many babies.
He's still an atheist, but claims these days that there's nothing wrong with most religious people that a bit of education wouldn't fix.
Ironically, I read a similar survey about five years ago that found that evangelical Christians were America's most unpopular neighbours - less popular than gays, Jews and pot-smokers. Of course, this was prior to 9/11, for what that's worth.
Kfish