You are quite right that there are indeed two variants of difficulty. I agree that one evolved with what is technically possible as you describe and yea, then there is that mental difficulty you mentioned about Morrowind.

I more or less basically gave up on these extremely complex games (mechanics and systems wise) because they (IMHO obviously) push you into spending too much time to do meta-research and studying. And I just don't wanna spend more time outside of the game than I do in game + this also starts to feel like "a job" to some degree. Or obviously you can be intelligent and very into it and perhaps realize how these mechanics work yourself but as you mention - some games are just extremely complex IMHO (usually these are strategic games but also others like competitive games, etc.) and the collective knowledge of the internet is in my opinion taken into account while designing these systems.

But yea, then there is that mental difficulty. I'd say Tunic falls into this category. And there are many games like these even among modern AAA titles sometimes (not in that "full scope" like say the mentioned Morrowind). But I wonder if there are people who came to these conclusion by themselves. I mean obviously these things got solved but how? Was it a person by themself or was it a collaborative effort on a site/chat channel or w/e?

Because I am thinking about this a lot and unless I am lying to myself, when I was a kid, I almost 100% FF9 (the only thing I didn't find/do looking back now is that I never did a speedrun (this concept was absolutely unimaginable to me until relatively recently even) so I didn't get Excalibur II and I haven't beaten Ozma - but I found it). And I wonder if that was just me spending a lot of time on the game, enjoying it and thinking about it and piecing stuff together eventually and now I am perhaps "unable" because my brain starts to react with "OMG this is impossible to do alone" quite fast. Or did also these mental difficulties ramp up over time? I am not sure to what end it'd serve but yea.

I mainly wonder if these "super secrets" were always meant to be solved collectively somehow or is it more of a modern take because internet/meta gaming or am I just intellectually lazy/dumb these days? For example let's consider that Excalibur II in FF9. The only hint a "normal player" has is that a card of it exists in Tetra Master but then you had to speed run the game (12 hours to the very last dungeon) and there you had to look around for it. Was it found accidentally? Or did someone data mine then? Or did some devs talk about it with friends and it spread? And same goes for basically any and all of these "super secrets".

My main point I guess is that I'd love to spend time with a game I love and try to find these things myself but I am quite unsure whether it's even possible for some of this stuff.