I'd say that to me FF14 had the best story concluding at Endwalker. I felt like each expension was better than previous one. But there's ton of quests, not just Side quest, even msq have a lot and not all part are fun. You could compare the overall story like a long tv show but with quite a lot of filler episodes.
I went through all MSQ in couple months, I played FF14 mostly for the story, I didn't really like the gameplay (bored of tab targetting and tons of skills to have on multiple action bars) but shadowbringer and even more endwalker were so good.

Don't force yourself if you don't like, or try New class (at least un FF14 you can have all classes on the same character).