Look you obviously just didn’t like it apparently, so this is a mistake, but:
the Borg Queen surviving what Janeway did to her was internally consistent with what we know and have seen about how the Borg work (putting aside for the moment that giving the Borg a Queen was dumb) and her diminished state was logical and made sense in-universe, as did the bonkers desperation of her last ditch plot.
Palpatine coming back was, as I said earlier, an unearned rug pull that was orders of magnitude more lame. If they had set it up even a little bit artfully, if there had been even the tiniest notion that that was the plan all along it not only would have been well-received but probably as close to beloved as you can get nowadays. But it wasn’t.