Also probably a rare case where there are a few Streisand effect's all packed together, where the cops at each step made it worse for themselves.

If they never did the raid in the first place, no music video, no "embarrassment". They could have cut their losses, and not made a big deal about it and probably way less people (including myself) would have ever heard about it.

Instead they decided to sue, which made even bigger news. Here they could again have chosen "You know what, maybe this is counter-productive, lets settle/cancel it", and again probably people would have cared way less about it.

Instead, they go to court, make a bunch of exaggerated and outrageous claims, one officer apparently cried as well, all in a public court room that is being recorded, again making it a bigger thing.

Finally, Afroman wins the case, leading to this now seemingly making international news, and the videos continue racking up views.

I know cops aren't known for being smart, but I have to wonder who made them act like this, don't cops have lawyers who can inform them about what is a smart move vs not? Seems they almost purposefully and intentionally tried to help Afroman, since they basically made the "wrong move" at every chance they got.

Yes, but not limited to just that one. https://www.youtube.com/@ogafroman/videos

He also has other videos where he calls one of them a pedofile, questioning their gender (Licc'm low lisa) and more.

So, in the music video, the cops pretty clearly steal something (probably money, as alleged), and attempt to destroy evidence.

They’re facing charges too, right?

Right?

here appears to be his celebration of his victory, pretty catchy https://www.youtube.com/watch?v=HM8Ee6pcXvQ

This might be peak Streisand effect.