Cyberpunk was pretty rad, but after trying all endings I learned about the secret one for which I didn't qualify due to different choices in some early dialogue with Johnny far before ending, which soured the overall experience for me...

I actually really dislike this sentiment. Gamers being upset they can't access secret content on a first, blind playthrough means that developers are incentivised not to include secret content.

It seems inconsistent to complain about needing outside knowledge to find something when the only reason you know about it is from outside knowledge. There can be joy in going in fully-blind and there can be joy in following a guide like a list of chores but the no-man's land in-between leads only to disappointment and spoilers.

(this is also why I don't watch movie trailers or read book blurbs)

To be fair, the way the secret content is "discoverable" involves a very specific sequence of choices in a single conversation that you cannot go back and re-make without undoing a lot of game progression. Old games didn't have the same kind of progression, and new games are generally more forgiving about post-game exploration of all the content in the game. The game also has misleading affordances that give the impression that your relationship with this character is built up over several conversations, when actually only this one specific sequence in one conversation is known to work.

So, I don't think it's bad because the content is hard to discover without outside knowledge, it's bad because it's both hard to discover and impossible to fix once you have progressed past that point. It's not like being able to just rewatch part of a film or re read a book chapter to get a reference. You basically have to reload an old save, go through a decision sequence, and then replay the entire last third of the game until you have access to a final playable level, and the way it's implemented feels like it was very much slapped in to take the place of a johnny-friendship-meter mechanic that appears mostly broken outside that one conversation.

The King’s Quest design aesthetic.

it sucked then, too.

But King's Quest is a lot faster to go through on a new run.

that’s a depressing thought.

I finished all main/side missions and gigs, let Johnny take over whenever he wanted and then went through all reachable ending combinations (8 different endings, even if slightly) and then I learned there is a secret ending considered the best of them all which was denied to me due to some obscure choice early. So no wonder it left a sour taste.

This seems common to a lot of games, and aims for increasing the replay value. I personally also don't like it, because I am absolutely not motivated to play through tens to hundreds of hours again and also don't have time for it. But it's still ok for me - I'll just watch whatever 30 minutes of end scene I missed on youtube if I'm interested in that.

I had the same issue except it was pretty trivial to mod the game on PC so I could do that secret ending.

Thanks for the tip, I'll look if there is a mod doing it that has not been patched yet...