I played a lot of other Final Fantasy's and a lot of gaming sites say that FF14 has one of the best stories in the franchise so I tried it out. This is an issue of the hype killing the game. FF14 has a good story but it's not as good as the hype makes it out to be so in the end I was disappointed. I can give you 50 games that had a better story than FF14.
The first issue is that there is too much filler in the story that adds next to nothing to the lore or the story. Having to play hide and seek with children is not interesting. Having to harvest vegetables as the freaking Warrior of Light is stupid. The game suffers from being an MMO by having to give you way too much filler.
The second issue is that the game can't be as immersive as modern story-driven games. The Last of Us 2 is capable of making you feel sad, angry, and horrified because the game is designed in a very immersive manner. FF14 makes you read the dialogues which isn't as immersive as modern story games.
The third issue is that even in world-ending, cataclysmic events, there is no sense of urgency. This is partially because FF14 isn't as immersive as single player games. It's also because there are way too many Mary Sue moments in the game where you expect someone to die but they miraculously survive. After a few Mary Sue moments you just don't expect anyone to die anymore. Because of that there is not much tension to be felt in the story.
I'm not saying the story is bad, but it's definitely not one of the best stories in a video game nor is it really even one of the better stories among the Final Fantasy franchise. I enjoyed FF14 and it does have a better story than WoW but I don't think it matches up to actual single player games at all. So I really don't get the hype and IMO people have just not played enough thought-provoking story games outside of FF14. Saying it has one of the best stories in video gaming history is an exaggeration at best.