I live in Florida, and I'll take the risk of hurricanes and tornadoes any day over earthquakes. Just the sudden and unavoidable nature of earthquakes makes them seem orders of magnitude worse to me.
Let the whole state go under. I'll be long gone by then. (All kidding aside, I haven't really heard anything about that, and it isn't a pleasant thought. Any particular articles on the subject that you've seen?)
Again, I don't know how likely this is, but Florida is one of the most vulnerable states in the US. The prize probably goes to Louisiana with North Carolina in the top 3.