Personally I find it fun to do to this day (I spent hours just running around and talking to Adoulin NPCs not long ago), but since I'm a quest/mission oriented gamer I never had to suffer with lack of fame so never had much use for rep checkers.
Although you are right, if you are new and only care about specific quests to advance then the fame system would be a complete wall for you. I assume it to be just poor localization, but either way Fame NPCs should be made more... famous around town.*ba dum psh*
There are brady guides or similar for most games though, this includes the modern hand holding games like WoW and XIV, and it has nothing to do with the game being playable or not, it's just that some people like buying guides for games.
Also, let's not forget Brady in particular has always been famous for it's extremely poor information and completely wrong directions and hints on a regular basis.
That said, I do agree that in many cases quests were too vague about the objectives you were supposed to complete, and NPC dialogue should've been revised to present the quest in a better way. BUT ! marks and handholding arrows on the map are NOT the way to do it. Just play XIV for a bit and you'll see just how much the world loses in terms of immersion when you do that.
I have for the most part. Yes, there are many quests that are way too vague to complete on your own, specially those that require some obscure item you really have no idea where to obtain or if it's even the right one if you obtain it because there is no log change nor any hint on the item itself.
But other than that I rarely use the wiki to "solve" quests themselves, and only use it for the aforementioned item quests or to cut search time of ???s in areas I already know. For SoA missions I usually found the places for the missions while exploring the areas, same with WotG and previous expansions before that. But I'm the kind of player that likes to explore areas so I usually know where the triggers may be once I need them.
I guess it depends on your playstyle, but at least to me the most important aspect of questing in XI is that I read every single line NPCs say, and I find it interesting. Which contrasts completely with almost all other Online games I've tried.
Take XIV for instance, I don't know what it was, but I found myself skipping 90% of NPC dialogue and just accepting quests blindly instead of actually bothering to read. Something I would never, ever have done in XI. And sure enough, the world became far less interesting as a result and I ended up not giving a flying damn about any NPC in that game. And barely remember the names of any npcs from the main story.
Whereas I remember almost all NPCs I've talked to in XI in one way or another. From the way Yoran Oran speaks to how silly the King of Fab is to how that taru girl Kipopo shred the handbag his father Hampu-Kampu had made in the war era.
And that is the definitive difference that separates XI from all the other games out there for me. Something that will be lost the moment you trivialize actually paying attention to what NPCs in the world say to you.
And really, if a player is going to skip it all they can just have ffxiclopedia open on their cellphones and be done with the quests if they really have to anyway.
No need to alter the way the game works, just need to revise and update the dialogue of the many quests that are way too vague to complete without wiki.