and I really dislike the RNG skill checks.

I disagree, I think the skill check enhances the character building, failing them often produces more interesting outcomes than passing, and passing them can create brief moments of victory for Harry. On my first play-through I was failing shit constantly except my build was pretty good for things directly related to the investigation, so it kind of worked for an RP were Harry was a washed up mess but he had been a good detective, so his past skills were shining through his amnesia and failure.