Wow, do you have a citation for that?
Edit:
States are apparently required to file an LESO operation plan. Here is an example from the Minnesota LESO operation plan
Section III. C.
> ... are required to utilize property within one year or schedule its return
https://dps.mn.gov/divisions/hsem/homeland-security/Document...
https://www.dla.mil/DispositionServices/Offers/Reutilization... has request forms.
https://duckduckgo.com/?q=Property+obtained+under+this+SPO+m...
“Property obtained under the SPO must be placed into use within one (1) year of receipt, unless the condition of the property renders it unusable, in which case the property can be returned to the nearest DLA Disposition Services Site. If property is not put into use by the LEA within one (1) year, the State/LEA must coordinate a transfer of property to another LEA or request a turn-in to return the property to the nearest DLA Disposition Services Site. All costs associated with the transportation, turn-in, or other expenses related to property obtained through the LESO 1033 Program, is the sole responsibility of the LEA.”
On the rare occurrences when it happens it does change how the agency involved approaches things in the future. See Waco vs Bundy ranch.
While there were no known punishments for agents/managers of the Branch Davidian incident, there was clearly a massive change in attitude toward using such tactics, lasting decades. The Elian Gonzales incident seemed a hesitating/reluctant resumption 15 years after, again avoided thereafter. The Bundy Ranch incident seemed ready to go there again, but was largely dissuaded by armed citizens. Of late, perceived rhetoric pointing toward resuming aggressive raids is increasing, but held back back per plurality of sentiment willing to fight back.
Note that I'm referring to incidents perpetrated by federal agents. Local police, as the lead article depicts, are ramping up aggressive raids faster - with some, as noted, learning by law or lead that doing so is a bad idea.
You tend to see the same thing in police departments where officers get shot conducting unnecessary no-knocks. Of course it never makes more than the local news.
The last I've really heard of someone doing that in America was the guy who flew his plane into the IRS building.