I came across this blog video by Penn (of Penn and teller) which struck me as quite insightful in it's own way about the nature of belief and the effect that having an atheist or non-atheist viewpoint can have on you when you experience the death of someone close to you.
Have a look and see what you think:
http://crackle.com/c/Penn_Says/Penn_says-_Atheism_is_a_Solace/2280592/#ml=o=9&fc=52&fp=-2&fx=
Have a look and see what you think:
http://crackle.com/c/Penn_Says/Penn_says-_Atheism_is_a_Solace/2280592/#ml=o=9&fc=52&fp=-2&fx=