Thats kind of the point, they're so (deliberately) underfunded they have to farm out jobs to subcontractors which boil down to "vigilante goes to place, murders a bunch of people".

I thought the game did a pretty good job of showing cops as a gang just like any other in Night City. Of the two cops you work with, one has a questline about the cops being shitty and negligent, and the other is a just fixer who sends you off to do illegal shit like all the other fixers, independent of the police.

Also the cyberpsycho missions were fun, what with the trying to nonlethally arrest super-powered mentally ill criminals to get them help before the NCPD comes in to straight up murder them.