After reviewing a bit of this thread, it seems that the people who weren't sure about the RE4 remake were won over by the gameplay, so much so that their issues with characters, tone, and such were made a non-issue.
I would like to get this game, but the intrusiveness of the remaining issues with the characters/characterization and retconning make this very unlikely. The propensity of developers to create a more cinematic experience by blending dialogue with action/gameplay makes it difficult to ignore awkward writing that can take me out of the moment. Then there's the character design which has been discussed at length already. I'll spare you my criticisms on that.
It sounds like lot of the changes might work better for a sequel than a remake, especially if they start messing with characters and plot. For example, if there's truth to the regenerator's being recycled assets from the mold people is true, then they could make them appear in RE9 as a hybrid of 2 existing monsters rather than resort to retconning. Maybe make use of those new characters they've been teasing (like Jake Muller who they seemed so proud of in RE6's ending).
Making Leon this affected by Raccoon City PTSD makes him a very different character than in the original. A lot of Leon's charm in RE4 came from his competency and keeping a cool head no matter what he was faced with. The Leon from RE4 brings a lot of his past experience to the game that gives him determination and ability to complete his task. RE4 remake Leon seems to bring more emotional baggage along with his experience and seems more antagonistic by default. In short, RE4 Leon is a hero while RE4 remake Leon is a survivor. Both can work, but my personal preference is the one with less baggage for getting the job done.
I could just find mods that fix some of these things, but I would rather play the original and save myself the hassle/money over trying to redeem a product that just isn't for me. Glad to hear that some people are able to enjoy the gameplay though. I just hope that the developers don't continue on with their trend of storytelling/characterization in their games. If they don't show some respect their IP, I won't either.