Sylas you should post your rankings each expansion as you go. They are much more concise. I am curious though, what is a 10/10 game/story in your book? Or even an 8/10?
In mmo space i don't think i'd call any story a 10/10. They're video games so will always draw comparison to similar media. They are at their heart rpgs thus they compete against single player rpgs, but with far more restraints (such as the necessity for multiplayer content, repeatable content, every other player is also "the hero", etc) which generally hampers the story. RPGs I'd rank 8/10 to 10/10 games would be stuff like Mass Effect 2, Witcher 3, Morrowind, KOTOR, etc. Also some older favorites like Planescape: Torment but it's been decades and idk if that's just member berries or my (at the time) teenage brain thinking that "killing your own mortality" was the greatest shit since sliced bread or what.
As far as MMO's go I'd give SW:TOR's class stories (1-50 base game) between 2/10 and 7/10, maybe even 8/10 for sith warrior or agent but that's a stretch honestly. The expansions vary from 3-4/10 for Hutt cartel to like 5-6 for TET. The new expansions sit in the 4-5/10 range. Other games that fall in to that 4/10 to 7/10 category are things like ESO, Secret World, etc. Most MMOs, especially older MMOs are just settings/worlds, they don't have a story. Claiming that FF14's story is better than games that don't have a story is ridiculous. Grat's I guess here's your participation trophy.
You have to remember there is more to a good story than simply action beats, and in a game like FF14 that's all it has, anime style action beats. Beat the big bad. beat the bigger bad, beat the biggest bad, etc. action beats is just 1 part of a good story, the connective tissue like writing, dialogue, plot, character development/arc, pacing, atmosphere, tension, stakes are all just as, or really, even more important, to string together the action beats and turn it in to more than just some cheesy hollywood style set pieces with zero emotional investment from the audience.
You may overlook weak writing or plot because you happen to be a fan of that particular genre but that really should not matter when you are objectively measuring the story's quality. I'm not a fan of stephen king, occult, conspiracy theories, etc, certainly not in a modern setting, but that doesn't detract from how good I'd rank the secret world. 10 minutes into that game you are hooked because they absolutely nailed the atmosphere, tension, writing, and other worldliness of their setting which greatly contributes to the quality of its story. it drops off by the time you get to Egypt unless you just happen to be a huge fan of Brendan Fraser's Mummy or something, but it picks back up by the time you explore Tokyo.
Generally this is the opposite of most opinions on this topic (talking 4.0 versus 3.0, post SB patch content is generally well liked), curious why you think this? Please explain
The beginning of heavensward is better than the beginning of SB, because hw's narrows its focus on a single city (ishgard) and explores the people there and their background. the atmosphere of Ishgard is superior. But once you get past the introductory questline and get to the plot HW is more like ARR in that it's kind of all over the place pulling on multiple unrelated threads (finding your friends, dealing with insurgents, the dragonsong war, the church, Allagan, etc) and it just kind of haphazardly pieces them together. What's the actual plot of HW? One of the nations of the Eorzean alliance noped out and hasn't participated in a while, go find out why. Oh, there's dragons. You didn't know there were dragons here? That they've been under siege for one thousand years? Nope they never mentioned that once back when we were allies and only recently withdrew back to within their borders within the last decade or 2. Ok well we overthrew their state church so they're back in the alliance now.
it develops a handful of NPCs then immediately kills them or otherwise takes them out of play (estinien), and leaves you with the 1 dimensional scions, some of whom you've rescued/reunited with, like they had the opportunity to reintroduce them as real npc's with depth but decided against it. Thinking back on this ARR did something similiar, by crippling Raubahn, the only character they bothered to give a personality/backstory to.
The plot of SB is just a tighter story, has a clear and focused purpose. You are fighting the empire trying to liberate its conquered provinces. You start off like every other story in this game just walking in and thinking since you are the hero and the good guy you will be handed everything with no challenges or even consequences whatsoever because that's all this game's story has done so far. And you lose. You lose big time, you get your shit pushed in. you have to fall back and reassess your so called "strategy" and how to deal with an enemy that actually challenges you, after killing gods and wiping out armies for 40+ levels there's finally some actual tension. not real tension of course (the game itself isn't hard), but the illusion of it, hurdles to overcome, an actual story arc.
People who compare this game to a TV show that starts off bad but after 3 or 4 seasons it get's good are kind of missing the point. A shitty show with 1 good season is not a good show, it's a shitty show with 1 good season. Let me start from season 5 if that's when it gets good. Oh but you won't understand what's going on or know any of the characters, you gotta start from season 1. Well i've started this game from season 1 and let me tell you, I still don't know any of these fucking characters because they are all 1 dimensional robots with no soul. Anyone you'd be interested in has already died. They had a golden opportunity to simply kill off everyone from season 1 (ARR) save for yourself, the protagonist, and could of started over. have Heavensward be about rebuilding the scions from scratch and going to ishgard for help. Going to ishgard, doma, ala mhigo looking for exceptional, fully fleshed out NPCs to rebuild your order could of been the thread tying all these expansions together and it would of been a lot cleaner than what they've done so far.