I agree BFA is a great starting experience. It is a good footing for modern wow, since Legion was kind of the big conclusion of the 'old story'.
FF and WOW are very different in story delivery however, and I think FF's story benefits from forcing people through it, while wow's is less so.
FF's MSQ is very focused from start to end, and is effectively a single throughline through the expansions up until Endwalker well, ended it. There's side quests but you dont really need to do them. Its raids are such are also more of side stories.
WoW's story telling is messier and with lots of side stories. This makes the world feel a lot bigger than FF's, and is one of its strengths. But each individual expansion is also largely a self-contained story. Also its raids are part of the story.
Its sort of like a serialized show (FF) vs an episode series (WoW). Even the player character in FF is a singular 'special', while each wow expansion finds a new excuse for the PC to be special.
Dropping into Endwalker would probably be very confusing especially with how tied up your character is in things. Whereas dragonflight you're just an adventurer going an journey to dragon land.