I go a ways back in gaming. I do remember (and still have) the notebook that was beside my 66mHz 486 that held my gaming notes from the days of my IIe all the way to Daggerfall (which required me starting a new notebook.) Drawing maps and notating quests for Ultima games, various games worth of cheats, hints, codes, and vice-presidents (the "age verification" question to play one of the Leisure Suit Larry games was how I learned about fmr Vice President Spiro T. Agnew.)
Console gaming DID kind of change things in that regard. I never needed a notebook. I don't think it was really such a bad thing though, just different. The games were more skill based at that point. PC DID have "smarter" games. Games that required more problem solving and less lightning fast reflexes. But that doesn't really "dumb down" games in general, rather just changes the focus from puzzle solving to reflexes and reaction times. And the PC was still there, so consoles just "added to" gaming as opposed to "dumbing down."
Plus as I've gotten older and my window for gaming time has gotten smaller and smaller (I wish I had the gaming time I used to have as a kid.) As such I do appreciate not having to pause to update my notes or map, or look at my index to remember where I wrote down the quest I stumbled back into after having left it behind days before.
But, I can see examples where it just gives too much away for some of us too. I think Skyrim's a bad example, I still believe the map and quest designers were trolling us with the markers. I ALWAYS found it actually quicker to follow a road or path than try to walk straight to the objective. With all the ribboning, layering, and terrain walls added to the map to make it seem bigger than it actually was; the markers led you into dead ends and wrong turns just as often as it would lead you directly to your objective. But anyway...
As a solution, how about a "conditional" quest marker system in some future hypothetical game. When you get the quest, only an area is marked out on the map as a guide. You could either explore that area and find the objective, or ask around and investigate. Chosing to investigate or ask for directions would narrow down marked area or give you an added arrow towards your objective. It's the only kind of hybrid I can think of that bridges between the option quest markers on/off.