The Last Jedi is the 2nd best Star Wars movie, period, behind Empire, IMO. Followed by Rogue One, so I can't agree with you on that one.
Rian Johnson gets so much insane criticism for TLJ, when he was just doing what he does - making great, original movies. If Kathleen Kennedy and JJ Abrams wanted a cohesive, overarching, three-movie storyline - like the guys down the hall at Marvel - they should have had it in place before pre-production began on The Force Awakens. Instead, you hire two directors to follow JJ who are both huge Star Wars fanboys and have visions of their own, and somehow you're surprised when the guy who takes the baton for the sequel doesn't walk a path he was never told existed.
If what they wanted was Luke coming back and kicking ass, they probably could have found out in a 10 minute conversation that Rian Johnson wasn't going to be their guy. But they gave him creative freedom! And the dude is an incredible writer and filmmaker; he probably looked at TFA and thought, "Well, okay, that was nice. But are we just remaking the original trilogy or...? Nah."
Then Disney doubled down on their mistake by, instead of taking things the new direction Rian had pointed them, bringing JJ back to steer things in to the most awkward, retconned, third-act ever. She's a...Palpatine? And an "ancient" Sith artifact is a map that matches up to wreckage of the Death Star that's like 50 years old? TF is happening?!
Ugh. Aside from the heavy-handedness of the Canto Bight storyline - there had to be a gentler way to impart to Finn that fighting for big causes is always gonna leave you empty, it's the "people you love" you fight for (or whatever) - TLJ is a freaking awesome movie.
(Also, I agree with you about Andor not being the blueprint for everything SW going forward. This is a project that fits a very specific type of storytelling by its very nature. It won't work for everything.)
Project Hail Mary was SO good. One of the times when the audiobook really added to the experience, too.