"There is a 63% probability of at least one magnitude 6.7 or greater quake, capable of causing widespread damage, striking somewhere in the San Francisco Bay region in the next 30 years." Source: http://www.earthquakesafety.com/earthquake-faults.html
And I would say it is not true that most of the value is in the land. Even if it is 50/50 between land/house, losing 50% of your investment when the house is destroyed is still a terrible prospect...
The 20th Century was "abnormally stable" in SF, and they've got a long history of fairly regular ones. http://www.mercurynews.com/science/ci_25793975/quake-cluster...
> and much of the value of the property is in the land, not the structure
In a normal "selling my house" situation, sure. In a "good portion of the city got leveled" situation, not necessarily.
Even if you have earthquake insurance, insurers typically go out of their way to avoid/reduce claims they have to pay (this is exactly what happened to numerous Hurricane Katrina victims: http://rt.com/usa/katrina-state-farm-insurance-fraud-596/ )
On the other hand, if you are renting and your house gets destroyed, you move to a new house and you don't have the financial liabilities a homeowner would have.