My relationship with player's guides has been a mostly positive one. I mainly remember using them for 3 games: Zelda Ocarina of Time, Zelda Majora's Mask, and Pokemon. At that age I was more easily wowed by the story and stuff like that so it didn't really bother me that I was more or less following a set of instructions.
I remember resenting how my Ocarina of Time guide didn't spell out exactly how and where to find all the gold skultulas. It felt as though they cheaped out on that part.
I don't recall using a guide for 100% of Majora's mask, it was mostly for the 4th dungeon and for the quest to collect 100% of the masks and obtain the Fierce Deity mask. Later when I replayed the 3DS Majora's Mask I found the 4th dungeon to not be as hard, I guess cause 10 year old me's brain wasn't as developed as that of 25-year old me (my age when I played the 3DS version). But the Fierce Deity mask was a P.I.T.A. Nonetheless I felt awesome getting it as a kid and likely would have never seen it if not for a guide.
Pokemon had some random fetch quests I couldn't always remember or figure out how to complete so the guide helped with that. Mainly though I used it like a rulebook to look up random minutiae, like how to evolve a certain species with weird evolution conditions, what moveset does this species and at what level, etc. Pokemon actually made a lot of sense to have a guide because there are so many statistics and intricate details and specific conditions needed to accomplish what you want that it's hard to keep it all straight in your head. The guide was more than just, "follow these steps to beat the game."
Today I'm mildly nostalgic for player's guides although now it's more about printed media full of pictures and advertising copy rendered obsolete by the Internet. It's similar to the way I feel about gaming magazines like Electronic Gaming Monthly or Nintendo Power.