I mean, police unions do exist solely to protect police officers which means their incentives are sometimes opposed to the public they serve, and so they should absolutely not be in charge of things like self investigations and time-limiting records of abuse, etc.
But that's not inherent to a union. Cities shouldn't cede these extraordinary powers to the union in the first place, and if they already have, they should take them back.