I'd argue 9 is still worse. Looking at it from the perspective of VII, Vader's sacrifice still at least destroyed the most terrifyingly powerful evil guy in the galaxy and let the Rebels topple the Empire. The heroes may have wasted the opportunity they were handed, but at least they had the opportunity.
But 9 goes further - now all Vader accomplished was minorly inconveniencing Sidious while the Rebels and the Empire fought over the arrangement of the deck chairs on the Titanic, and the real evil empire chugged right along putting the final coat of paint on their billions of portable Death Stars.
Not really, no. Episode VII showed us that Palpatine SHOULDN'T have been killed. His death caused a power vacuum that led to an ineffective New Republic and a militant First Order rising in the place of a once-stable Galactic Empire. Under Palpatine's Empire, if you kept your head down, you'd live, 90% of the time. And Palpatine, at most, destroyed one planet and a few warships with his Death Stars. Somewhat destructive, but small-scale, in the grand scale of things. And in most cases, the Empire kept people safe so long as they obeyed. Come Palpatine's death, and the New Republic is shown to be ineffective at holding the Core Worlds, and the militant First Order has no bones about destroying five planets with one shot from Starkiller Base. The Core Worlds got a useless government, while the Outer Rim was overrun by a violent Imperial remnant that was a pirate state in all but name. Far from justifying the heroes of the OT, Episode VII shows us that their actions led to an even worse situation, since both the Core Worlds and the Outer Rim were stabilized under the Empire, and OT Palpatine was nowhere near the nutcase Snoke was when the latter ordered the firing of Starkiller Base. Far from justifying Vader's sacrifice, EPVII showed us that not only was it uneccessary, but it doomed the galaxy by destabilizing it.
At least Episode 9 is just a silly space epic where stuff blew up and Palpatine looked cool. They realized that they already raped the OT to hell and back with TFA and TLJ, so they might as well finish the job and have Palpatine come back and chew the scenery for extra brownie points.
Also Sidious is both young and is now technically the only living Jedi left according to everyone around his new meat suit. Sith victory in pure totality, and hilariously close to the Dark Timeline that
@GeneralFriendliness referenced a few times.
As for me, I partially faded out with Rogue One, since I felt like it was a schizophrenic movie that didn't let things breathe and didn't know quite what it wanted to be. TLJ and the contempt shown by the company utterly nuked any chance of Disney getting clicks from me until massive shakeups occur. Plan IX was just me watching the drunk and retarded people put the coffin that contains the franchise in the shallow grave after pissing on it and looting it.
Yes, that story would have been great, Rey Palpatine being the new Voice of the Emperor for Sidious. That would never be something Disney would do, though, unless some real sadistic nut (like me!) ends up taking over Disney to approve that kind of story.
Rogue One was a bit schizophrenic and canon-breaking. I'd much prefer Dark Forces, but taken on its own terms, Rogue One is still okay, but it was schizophrenic because the creator wanted a gritty war movie and Disney wanted a fun space adventure for kids.
TLJ was just Disney giving the bird to the fans. Back then, they could afford it, because the parks and the money coming in from the parks kept them afloat. Now that the parks are ghost towns, they've got no choice but to back down from the canon-raping of TLJ and beg for the fans' forgiveness with S7 Clone Wars and the Mandalorian.
That's a good description for EPIX. It's basically the equivalent of me going into Freedon Nadd's tomb in KOTOR 2 and looting his lightsaber from his corpse after I robbed the rest of the place.