I’ll be honest, I actually do think you can make some logical sense of the original film’s take, even if it’s pretty silly.
Palpatine from the start wants Rey to come to Exegol and take over his spirit. He basically lies to Kylo knowing that he’ll reveal to Rey her backstory which will just make her want to come to Exegol more. Meanwhile he figures that Kylo won’t actually kill her, and even if he does he can just take her place. “You have his power” seems to be more neutrally “you have a lot of power” or something. Even in Kylo’s mind, he doesn’t know about the essence transfer, so if Rey is destined to kill Palpatine then he doesn’t see why Palpatine wouldn’t want to stop it.
Things definitely get more complicated when we start changing things, since most of this logic you kind of have to figure out on your own, it’s not explicitly stated to begin with. I’m gonna have to think this through for sure in terms of where Kylo fits. Is he trying to stop her from killing Palpatine, or is he trying to get her to fulfill the vision. I will say in my version he still doesn’t know about the essence transfer. I kind of like the idea though that he might be trying to stop her regardless. Wonder if we could sneak in a line like “Palpatine is a distraction,” something that gets that point across. So his offer is really more about the dyad thing specifically. I wish we had that oracle scene, apparently it told him about the dyad. Tricky stuff here.
I’m not in love with my bad parents but still revenge solution, but personally I’ve yet to be convinced of a better solution. I don’t believe that Rey having bad parents would be enough to stop her from wanting revenge for their deaths. These are still people she’s been emotionally attached to for almost all of her life, and this is the dark side messing with her mind after all too.
The way I see it, the biggest issue with the way you and I have it RL is that Kylo (regardless of whether he knows of the energy transfer) tells her she’ll kill Palpatine and take the throne. She then immediately says she’s going to kill Palpatine. So what’s going on there? Obviously there’s the revenge on the mind potentially, but she should be worried about killing him? It makes sense for later on Ahch-to but…