Off-topic, but there’s a character in Disco Elysium that perfectly encapsulates your comment: Evart.
In addition to helping you find your police-issued gun, the dude is an absolutely corrupt asshole, and does everything for the wrong reasons. However, he’s in charge of the labor union for the harbor in the city you are in, and he actually does a lot of good things for the workers - not because they are good, but because it furthers his political base and, if you take him at face value, he truly does believe in protecting the working class. Evart does everything very lawfully, so you can’t really arrest him for anything illegal because he hasn’t done anything illegal. So while it’s very easy to write him off as LE, he does have enough nuance to arguably be considered LG in some cases.
Yeah, following laws because they're the law with no regards to whether or not the law is just gets into bad places real fast. Opposite problem with chaotic good: automatically assuming that all laws and rules need to be opposed to do good leads to iffy or worse stuff too.