The game and its current state

[Adire]

Firstly, I think you're confusing the quality of the narrative with how the storyline is relayed to the player in the form of quests, because the two are totally different concepts. It seems to me your problem is how the quest system in FFXIV holds your hand with telling you where to go and what to do, rather than just giving you a basic hint and leaving it up to you to figure out yourself. In other words, like FFXI's style of questing: (more coming)

Nope. I'm not fond of the narrative either.

Although some might find that style of questing to be fun, really in practice it turned out not to work quite so well - all it does is drive players to look up online guides for the information, inevitably leading it innacurate and incomplete quests as people struggle to find out what they have to do exactly. All the ARR system of questing does is cut out this middleman and tell you what you need to do simply. If it's that much of an issue, turn off the Duty List and quest notifications in the Config.

The Secret World's investigation quests actually turned out well. In fact, it's one of the most praised things about the game's questing system. It requires the community to work together sometimes, other times it simply requires you to use your brain on your own. You could always spoil the fun if you wanted, but you don't have to. And when quests are first released, it's always been really fun to see the community work together to figure them out.

Not sure if you've heard of The Black Watchmen, but it's a "game" with a similar take on things. The vagueness of the quests in FFXI seem to me more like laziness to try and make them challenging by just simply leaving details and forcing you to fill them in out of nowhere rather than intentionally making them challenging without being just vague, as in TSW.