This will make me some enemies on both sides, I'm sure.
I'm a foxhole atheist. I also grew up in a Southern Baptist church. I've been on both sides.
I don't think that there is necessarily a problem with being a person of faith in itself. The problem comes when all rational thought goes out the window in favor of the "Good Book." I've seen it too many times for me to be comfortable when people start quoting (often out of context) Bible verses at me to prove a point. That tells me that they have put almost no thought into their position and are instead parroting things they heard from the pulpit.
I have also seen, from the other side, this almost religious type worship of an anthropomorphized version of science. It seems that a good chunk of people are looking for some sort of higher authority and end up replacing one with the other instead of actually allowing themselves the freedom of real free thought and the burden of uncertainty that comes with it.
Back to the religious aspect, though. If someone followed say, the Thomist doctrines and followed the laws contained therein, there would be much less reason for people of science to have a disdain for people of faith. Thomas Aquinas might say (paraphrasing) that in order to know God we must know his creation, and that careful, thoughtful examination of God's creation (physics, biology, etc.) necessarily brings one closer to God. Thomas Aquinas also said something along the lines of (again, paraphrasing) "If scripture and science disagree, then we are either comprehending scripture wrong or the science is wrong." I don't really agree with that notion, but it's one of intellectual honesty that I can respect.
On the question of morality, I think that the question comes down to the moral maturity of an individual; which is whether or not they have achieved post-conventional morality. As far as I'm aware, most do not achieve it and need some sort of framework to make their moral decisions on whether that be a holy book, the legal system, or their wise old grandparents. I do not know, and I do not believe it has been discovered, why most people are unable to achieve post-conventional morality. I'm not a philosopher, and most certainly not a scientist. It could be biology, or maybe the environment in which one is raised. It could be the ability, whether taught or innate, of an individual to take responsibility for their own actions.
Yeah, I rambled. Sorry, it's a topic that really interests me. I have a devout Christian friend that I served with that I argue with constantly. We're the best of friends (really, he saved my life) and we don't disagree on a lot of things, but we respect the heck out of each other, even when we are passionately arguing over drinks about religion and the supernatural as a whole.