Cat had a complete psychotic breakdown and went insane before she died. There's really nothing to indicate that her ressurection is fundamentally different than Beric's other than the manner in which it occurred. She was dead longer so her body is more broken down, but she is still the same Cat that she was at the moment of her death, just a little bit less, just like beric.
Did you quote the wrong person? I'm not the one arguing that Jon is going to change; I'm just curious if Jon is going to be the living dead, (Like LSH) or alive, like Beric was.
And as an FYI, they were fundamentally different. Beric was resurrected - I suspect that he was "brought back" and thus had his memory fucked up from doing so. Catelyn wasn't resurrected; her corpse was just given Beric's "spark of life" as they referred to it. She's locked in the state she was in at her death; mental breakdown and extreme lust for vengeance.
It's Lazarus compared to Frankenstein, basically.
As we were left just seeing Jon wake up, we won't know till next Sunday. It's possible he was brought back ala Mel, and thus is alive. (Possibly confused and/or with parts of his memory missing, like Beric, but otherwise still the same) But it's also possible that his life was simply exchanged, perhaps with someone who had just died at the wall and/or Mel giving her life instead.
I don't think Jon will be that different, with the sole exception that his current situation could twist things a bit. IE, what will his reaction be? LSH gives no fucks whatsoever, and I think part of that is because her family is dead and scattered and she's...well. Like, what else are you going to do to her?
If he's alive, you could kill him again, essentially.
My money is just on a pure resurrection. He'll be alive, he'll heal, and he'll be extremely pissed.