This dataset https://www.ncei.noaa.gov/access/billions/time-series does not cover every extreme weather event, just large ones, but it is at least adjusted to CPI.

Also it’s not getting updated anymore because usgov is currently in ostrich mode when it comes to climate change.