Mixed feelings on it.
If you are going to get one of the Gen 7 games, without playing any of the others, this is the one to get. More pokemon in the main campaign to use, slightly better pacing on the story in the early half (Though I'll get to the later half later on), even more wild and challenge Totem Fights than the original set, plus significantly more post game stuff to do with Battle Facility, Team Rainbow Rocket, Ultra Space etc.
I don't like a lot of the story changes it does though, they sorta butcher the Lillie/Lusamine arc by crow-barring the Necrozma and Ultra Recon Stuff into the game. The Ultra Recon Squad might be the worst villianous (?) team in the entire series, turns out adding a third team to a game that already have 2 to begin with wasn't going to work. It also has one of the more BS Boss Fights in the entire series with Ultra Necrozma (Either you will steamroll it, or Ultra Necrozma will steam roll you, that's basically all there is to the match.) and a worse final boss.
I also have mixed feelings on the Rainbow Rocket storyline, yes, it's cool to see all the Villainous team leaders and fight "Victoious" versions of them with great remixed themes and each leader having one of the region legendaries as part of the team. But it's bogged down with filler fights against laughably easy Rocket Grunts.
Yep I'm sure this Arbok is going to really stop you after you've taken down a Dialga.
There are 4 Arboks from Grunts alone in the Rainbow Rocket area as well. It's a problem with G1 Pandering where it's only the Rocket Grunts you face (No Plasma/Flare/Galactic/Magma/Aqua grunts with unique themes) and they only use Kanto pokemon to the point where they run out of standard Rocket Kanto Pokemon about halfway through the post game story (Despite also being the villain team of Johto...), it's even more egregious knowing that next year they were going to remake the first generation anyway with even more Rocket Grunts with the exact same pokemon to beat (At least US/UM gives Team Rocket and Giovanni unique battle themes to make them stand out, Let's Go didn't even bother giving them a unique theme! Just the regular old battle theme you've already heard billion times already.)
So... I can understand someone saying either Sun or Moon is better or Ultra Sun and Ultra Moon is better. US/UM have the better gameplay, but maybe don't change enough to justify the full price tag (Espicially compared to Black and White 2). Sun and Moon also have some better story beats to go with it whilst USUM sorta drop the ball on the last island, hard.
Still, both are significantly better options as a pokemon game to play right now than the trashfire known as the Let's Go games. I recommend these titles easily. They are also going to be the games that will contain the most pokemon in them now going forward... that's a weird thing to say.