It doesn't appear to be a thing in quite a few states, and where it is, it seems quite limited. Thus, the only legal remedy is lawsuits, which is why qualified immunity is such an injustice.
The most common attempt at a solution to this problem has been "civilian oversight," which typically takes the form of a new department of the city government that is responsible for auditing the police department and/or investigating department actions (in response to citizen complaints or on other triggers). The civilian oversight department is typically firewalled from the police department through means like a prohibition on staff moving from one to the other and an independent governance structure.
Because of collective bargaining agreement constraints there's usually still a PS division and some confusing work breakdown, where one audits the others work or the two perform independent parallel investigations or similar. There are some good reasons for that (doesn't necessarily make sense to have an independent civilian oversight agency reviewing every minor policy violation), but it often feels like waste.
Weird examples that never go away, you can see instances of these every single day:
- Tons of LAPD drive with illegal tints & no tags on their personal vehicles
- Tons of NYPD park in the bike lane or on the actual sidewalk
There are twitter accounts that follow these easy to spot examples. Harder to track: abuses of power in small towns when no cameras are rolling.
DAs have even more leeway in some states than others, for instance in New York felonies can only be charged via grand jury unless waived by the defendant. This gives a DA unilateral power to sandbag any indictment they don’t feel like prosecuting without looking soft on bad cops (see the Buffalo shoving incident) with zero transparency.