I agree with what you said about Rogue One. That opinion isn’t shared by all the fans or critics though. Rogue One showed the gritty desperation and some moral ambiguity with the Rebels which felt unique. It also deepened / enhanced the story of A New Hope.
I thought Solo sucked and was also disappointed with Obi-Wan. To me it lacked emotional connection and the telling of a good story. It was obvious Disney just hired lazy writers to milk the franchise for money.
If you want to watch a truly great relaunch/spin of a classic film trilogy, check out Cobra Kai. That’s now the gold standard of how you both satisfy existing fans and bring in new ones.