Sun & Moon were very good story-wise. I don't know about the "Ultra" updated versions, there wasn't enough new content in those for me to bother with them.
Sword & Shield were mid at best.
Legends: Arceus greatly shakes up the formula. Its story is nothing special, but I greatly enjoyed it all the same - much more than I have any Pokémon game since... what, Black & White? Fortunately it looks like Scarlet & Violet are taking a page from this one...
Not interested in the Gen 4 remakes. They take steps backwards, unlike the other remake games that kept the modern feel but applied it to older regions.