Permanently missable secrets and a lot of farming are things that lose a lot of interest. I'm having trouble with ALL square games, there is just too much farm.
The revamped FFVII on PC (own it on Steam) and I believe on consoles (not the remake) has boosters and random-battle skipping, as well as other features (like fast forwarding, I think). It makes it more approachable and less time-consuming to get through the game. The random battles time fillers are practically eleminated, and understandably make the game a breeze, as well, which removes much of the challenge.
As a teenager, I had plenty of time to explore the ins and outs. Nowadays, especially since I hit 40 recently, I realize I don't have the patience for such nonsense, either. My Steam backlog is at almost 3000, meaning I'll need a few more lifetimes to do them justice. Nowadays I'll just focus on one or two games till I finish them, and sometimes, when not tired or sleepy, sample others. The thought of games like Factorio fascinates me, but also turns me off. Especially the rogue-like genre games.
Square has updated, I believe, all their FF series games with this in mind. These features are optional and can be enabled/disabled on demand, as well.
Oh you are on a similar boat as mine. The problem I have with the remake is that it's not turn based, this means it has to compete with other action-based games and I have more interesting games to play in that department.
The old one had a very interesting materia system, that is still unique.
I'm like you, I have 1000 games to play and I usually go super deep in what I play, so it's rare I finish anything before 50 hours. Given that, I'm at a beautiful point where I cannot play games that are just good, only great games.
I do love factorio, although I think dyson sphere program is better (lighter and more interesting).
In 2020 people were complaining about lack of games, while I had my incredible year with Ori and the blind forest, ori and the will of the wisp, dyson sphere program, hollow knight and xcom 2. That was my best year probably.
Sorry for the wall of text. All of this to say, square enix doesn't innovate, I prefer indie gamea, gameplay for me it's everything. Plot is nice, but i'd rather watch on youtube if the gameplay is average.
And yeah, if there is farming that's not fun, I drop the game or occasionally I look for cheats to skip the farming.
This allowed me to play monster hunter iceborne endgame, which requires thousands of hours, in single player and by enjoying it way more (very strategic when changing build doesn't cost a fortune). Had a great time with it, but I was about to drop it when I realized how much farm it needed