Disclaimer: I live in Chicago, and my primary concerns are water in the basement. Secondary to this are cooling and heating.
I've been thinking a lot about this lately. My uncle just had some bad flooding due to a prolonged power outage, luckily his boiler was rebuilt and saved, but the water heater and softener were toast. The well pump appears to have survived, but he's going to replace it anyways. For me, a flood of that magnitude is unlikely, but not unprecedented. With the improvements to my house since it was built 92 years ago, along with our infrastructure, I'd like to think it is impossible, but I know that would be foolish.
I've come to the conclusion that before I go to Canada leaving my wife alone for a week, I'll be AT LEAST buying one of the Harbor Freight 2-stroke generators and an emergency pump. I'll show my wife how to use it--for her, the instructions will be easy: "Use these gas tanks, start it like this, plug this pump in to the generator, put this pump in the sump pit, and run the hose out the door down the driveway". That will be the primary concern. We can lose all the food in the fridge, we can go without AC. This is what is within our means right now, and it is the bare minimum emergency protocol if we get a 100 year flood.
Longer term, i.e. a year or so, I'll be considering either one of the Predator Inverter generators or an auto start, natural gas one like Robbie has. I think I'm going with the Predator option just because it is portable, in case my in-laws need it. I'll need THAT to run the sump pumps, fridge, and gas furnace. I'd probably throw a window-unit in in this situation.
I've also told my brother, who lives in North Carolina, that he should start stock-piling these things as a money maker during hurricanes. Based on what he saw last year, I figure that worst case he's sitting on them 2 years, and can sell them for 25-50% return on investment.