I agree with the general consensus that Rogue One is, by a good margin, the best non-OT SW movie.
What I think is interesting (and tragic) is that the other films all fail in different ways.
The Prequel Trilogy is an interesting story, with a clear arc over the trilogy, told poorly. It fails on a number of levels (dialog, special effects, Jar Jar) but at least it ends up where it was clearly aimed from the beginning. (And in general, I agree with the consensus that they get better as they go, with RoTS achieving general decency.)
The Sequel Trilogy as a whole is kind of a mirror of the prequel trilogy. It’s a horrible mess of a story, told fairly well (at least, for the first two movies). Read on:
The Force Awakens is probably the most damn fun of all the non-OT movies. It has interesting characters who bounce off each other in a fun way and who are not, themselves, just retreads of previously existing characters. It opens up at least some interesting avenues to explore (a stormtrooper not wanting to be a stormtrooper any more). But… its story is just a rehash of ANH to a fairly ludicrous decree. And it uses up and spits out the OT characters and the potential for seeing where they end up at a furious pace.
The Last Jedi is probably the most interesting and though-provoking movie for movie’s sake. It offers a lot of commentary and stuff on SW. But… you don’t go to see a SW movie, at least one in the main series, to see lampshading and deconstruction and commentary. It does a lot of things well. But it has some massive flaws of its own. And it does an AWFUL job of following up TFA and setting up episode 9. (And yet despite the awful job of setting up it does, Ep 9 manages to still fumble the handoff). TLJ is interesting in that it’s both over and under rated. It’s much better than the ludicrous scorching hate that internet edgelord fanboys direct at it. But fuck-the-edgelord types then react by overlooking its flaws and making it out to be better than it is. Imho.
The Rise of Skywalker is the worst of all worlds. It’s a hot steaming mess. It’s awful. I have very little good to say about it, other than that the actors, who are all good, really try.
Rogue One has been covered at great length in this thread, and I generally agree.
Solo tries to be Rogue One, and is… pretty good. Any SW fan who hasn’t watched it would probably enjoy it.