I had probably more of an issue with the main story, to the extent there was one, than with the side stories. I didn't mind the casino escapade, for instance. But one of the two main arcs is really just 'rebels are chased by First Order', from the opening to the end - also in terms of in-game time, it's all set within a very short period of time. With really very little that interested me going on. Or that made sense.
The other main arc, Rey's plotline involving Luke and Kylo Ren, was a lot stronger, but still not exactly wow. Snoke proved himself to be a lot of big words but irrelevant when it came down to it, already forgotten two minutes after he's dead. Kylo Ren is indeed the most interesting character in the movie, and it potentially sets up a third movie in which he remains emotionally conflicted even while being the undisputed leader of the First Order / Dark Side forces, so that's better than it could've been.
If you compare the status of the story before the start of the movie and after its end, it's kind of remarkable how little has changed. Rey and Kylo Ren have developed and created a kind of connection, and Luke is now not merely absent but actually dead, as is Snoke. That's really about it, if you ignore unimportant minions or secondary characters. Now, it's traditional enough that the respective mentors on each side have to die at some point and let the young heroes step up as new leaders, but generally in a trilogy, the second installment does contain rather a lot more than that.
I'm inclined to rank it near the bottom, myself. The much-maligned prequel trilogy suffered from less likeable characters, you could say, and I don't mean just Jar-Jar, but it offered a lot more in terms of plot. And I'd also rank this below Force Awakens, which was also not that great but had more charm and variety at least.
Killing off Snoke like that seemed weak. He was the villain. We didnt get his back story. We didn't get anything about him. Then he is dead.
At least Rey has the Jedi books and Luke, I am sure, will be around as a Force Spirit in IX. Still, it felt like this episode could have been 30 minutes and done.
Probably the best part of the film was Rey on the island. Yes, there was humor there which is not usually part of Star Wars. But still enjoyable.
My only true question is if Rey's parents are indeed unknowns or if Kylo was lying.