I liked it overall. I've been rather critical of the series since after Black and White, but Sword and Shield really brought me back, and I haven't really enjoyed the story of a Pokémon game in a while! I think they've set-up a lot of fantastic concepts, made some really strong characters (BEST Gym leaders), set-up amazing world-building through the League Challenge, and I personally think Hop is one of the best rivals we've ever gotten.
I really like everyone else too, but my biggest issue with the writing is the pacing. Unfortunately, the game's story is definitely extremely rushed, and I felt like they weren't able to tell every single bit of the story that they wanted to tell. Like, I think everything they set-up was initially pretty good, but the big story moments fall flat when they're built and and put down so quickly at the same time. It's very easy to notice how quickly all story events go after around the 5th Gym (All rival arcs besides Hop, Spikemuth, and Macro Cosmos are the biggest offenders) and it really gives off a feeling of a rushed game :/. I think the dialogue itself is kind of annoying but not bad, and while I love Hop, he could be less "on the nose". They just missed a lot of opportunities to do more, and that's probably the big thing I wanna mention.
I think the specifically the epilogue was really well done (some genuinely cute moments and people finally finding themselves), and honestly, they're going in a good direction overall if they keep it up and... take a bit more time.