This raid was in Ohio. Here's their immunity waiver: https://codes.ohio.gov/ohio-revised-code/section-2743.02
Here's a page that links to a PDF with a table given cites and details for all 50 states: https://www.mwl-law.com/resources/sovereign-immunity-tort-li...
People routinely get money from excessive force used by police officers, and I believe that does extend to property too.
Qualified immunity means it is almost impossible to sue the officers directly, which is why so many people have a problem with it. Not only do taxpayers have to pay for the actions of a bad police officer, the officer themself isn't held responsible for their actions.
On the other hand, you don't want officers afraid to engage with a dangerous situation because they might bankrupt their family if they do the wrong thing in the heat of the moment. It is a sticky situation, and before smartphones and body cameras there was no real way to know if an officer crossed the line. As technology improves, I expect there to be more personal accountability, while also allowing the officers enough leeway to do their jobs without hesitation.