I think the only thing I would disagree with is that the annihilation of consciousness is not a terrifying thought. There is nothing to be feared in non-being once you're there, but aren't you afraid of entering that state of non-being?

This. This is what I meant by fear of non-being. It's like limits in mathematics. The fear exists up until the point of non-existence but never actually reaches that point.