In over 40 years as an electrician I’ve only had to reset a main 100 Amp breaker once in a home, the cause was loose terminations on the main lugs causing the main breaker to heat up and trip prematurely. I tightened them, problem solved. Your problem may have been from the inrush current when the power came back on, can’t say for sure. It’s always a good idea to get an electrician every few years to go through your main panel and snug up terminations on your main breaker as well as your branch circuit breakers, money well spent. 90 % of my after hours emergency calls on commercial/industrial buildings were from terminations that had worked themselves loose from thermal expansion/contraction from varying loads over the years.
I'd also add a whole house panel surge protector as well.
Not sure why more people don't do this, shoud be standard equipment IMO. (it is required in the US)
