Of course today with our increased population and cities affected, the result will be quite different, and there won't be a quake in California that can compare.
That's fine, to each their own.
I agree about the New Madrid fault. It made it into the news a few years back when some seismologist predicted it would slip again...and didn't, which means the pressure is still building.
However, about California, a little closer inspection of the San Andreas fault, in concert with plate tectonics, will reveal a thousand mile long fingernail sliver barely clinging to the continent and looking for an excuse to plunge into the Pacific. Add to this an undertanding of the Pacific "ring of fire" and that the west coast of California has very little continental shelf off the coast, and that mile high tidal wave Robin Williams joked about years ago doesn't seem so funny anymore.
BTW, Yellowstone is a huge volcanic cauldron. Underneath the midwest corn belt is an immense cavern that *used to* contain ground water.
Aside from hurricanes, the gulf coast is probably the most environmentally stable in the nation. We've only had one minor quake in the twenty years I've lived here, and it was centered out in the Gulf. Most people didn't even notice when it hit (but I sure did!). We just put up with the all too frequent sink hole, some of which are large enough to swallow a car or house. Local history says there used to be a huge lake around here that stretched for miles, even had steamship service from town to town, until a sinkhole opened up sometime in the late 1800's and the lake drained within 48 hours, leaving ships stranded and creating a huge fish kill. We know the area today as Payne's Prairie.
Paynes Prairie - Wikipedia, the free encyclopedia