How long do Hurricane/Tropical Storm related power outages typically last?

It's my first hurricane season on the Gulf Coast/in Houston, and this season is predicted to be quite active.

I'm working on stocking up on supplies and one of my biggest concerns is power outages.

Losing A/C in this heat would be killer for pets/elderly/children, so I'm thinking of getting a generator. Even just a tiny unit to run a fan would be better than nothing.

People up north in CT and NJ have lost power for 4+ days due to the latest storm.

How did Houston's power infrastructure fare during the last couple major storms? Did your power go out, and if so, for how long?