Here in Australia we are well known for our religious indifference, much to the chagrin of the faithful. However even in this environment many will openly profess disbelief in God, typically Christian, though still reluctant to embrace the term 'atheist'. I'm willing to use the term and, to be honest, have not felt any particular antagonism from others including family members. Admittedly, most of them are atheist or atheist-friendly any way.
From postings at Atheist Nexus, though, many members feel threatened by the public knowledge of their atheism. It appears that, in many communities, atheists are still treated more contemptuously than other traditional social outcasts. Is this particularly true in parts of the US?
Alex's Heresies - Embracing a Physical Reality