I have read the majority of these books and agree they are all scary!!!!
One more to add to the list..."Lucifer's Hammer" by Larry Nevin and Jerry Pournelle. It is about a comet that hits the earth and how the different characters make their way thru destruction and chaos, eventually converging at a "safe haven."
It's scary because it is so realistic and the author really puts you into the action.