I put in a 20kW diesel generator many years ago and we've never needed it for storms, knock on wood. Did use it last year for a planned 1/2-day outage when the power company was changing transformers on our road.
Prior to owning a generator at this house, we had several severe hurricanes with outages lasting 1-2 weeks at our old house. I still remember what that was like, and feel good knowing we are prepared here at the new house. Winter isn't so bad since we have a good fireplace with a lot of wood stored, but in summer heat/humidity, it can become unbearable real quick without A/C.
The beauty of diesel is that I can easily store enough fuel here for a couple weeks of operation running continuously (55 gal will give me about 5 days of continuous operation). That could be stretched out if we needed to. In fact, I don't anticipate we would run continuously if there was a real crisis. I would probably only run the generator enough to keep us comfortable and safe, and then we could go for many weeks, even months. I normally keep on hand 55 gallons in the generator's tank, and another 25-55 gallons in my transfer tank. I have spare drums to store another 165 gallons if needed. I can get plastic drums for $5 each locally.
Another nice thing about diesel is that I can cycle it through my tractor and RTV so I can keep rotating my supply. But with proper treatment you can store diesel a long time (longest I have gone is about 7 years with no issues).
We are all electric too, with geothermal, and part of my decision for diesel was realizing there was no need to have a propane tank at the house. Dealing with that just for a generator did not make sense to me.
I recall spending about $7K for the generator (ordered/shipped from Central Maine Diesel), and another $1K for electrical parts to install it (I provided all labor). If I remember right, commercial companies wanted about $15K to install the same setup (which included install pad/enclosure/tank, trenching, wiring, hookup, permitting, etc). It seems high, but after putting in the time/labor and doing the research to gain the expertise, I totally agree with their quoted costs.
If you go with a Generac propane generator, look into the water cooled units. They have a much longer service life and they run much quieter and cooler (1800 rpm versus 3600 rpm for the air cooled units).