I can't really put Rogue One ahead of 4 or 5. Especially not ahead of 5.
I'd put this one between 6 and 3 (or 3 and 6 if that's your thing).
Its strange but as much as I didn't want the previous movie to follow the plot of the originals, but it did, I felt like this one needed to mirror the originals more, but it didn't.
I wanted Luke to be a badass. Ideally like Vader at the end of Rogue One, but minimally like the elder Dr. Jones in The Last Crusade. Instead he's a grumpy old man who barely helps at all.
I don't understand why the last two Star Wars movies have done little but tarnish the legacy of the icons of the previous series. Luke was a hero who turns into a failed instructor who leaves the known galaxy to sulk for thirty years. Han thirty years later was a loser who was barely staying ahead of the bounty on his head. He never increased his station in life or earned any semblance of retirement. Only Leia at least made something of herself, but she let the galaxy fall fully back into the hands of Empire, and she barely developed her own force powers. Maybe Lando will return in the 9th movie to lead the Alliance / Rebellion?
In Star Trek Generations, Kirk at least died fighting and kicked more bellybutton frankly than the TNG characters did. The Star Wars elders deserve at least as much before throwing the reins to the next generation.
Rogue One showed us just how much the Rebellion sacrificed to defeat the Empire, maybe Luke and Han should have watched it and appreciated how much was given to them. I don't actually blame the characters, I blame the writing and I blame Lucas for waiting too long to make these movies, and if he wasn't going to do it he should have sold to Disney 10 year sooner.
Anyways, I really wanted The Last Jedi to be another Episode 5, in most ways that can be interpreted. It wasn't. It was still worth going to the movie theater to see, but I left the theater annoyed at its treatment of the classic characters.