I definitely know the feeling, but for me that is a part of the game that is confusing in the beginning, yet very satisfying later in the game.

I think the best games/ games with great longevity have to have a somewhat complicated or deep attribute/ skill growth system to keep things interesting as the game progresses. I'll use Skyrim as an example. It was my first TES game back when it came out in 2011, and I was very overwhelmed not only by the skill/ perk/ attribute system.. but also by the sheer scale of the game and deep lore. I had no idea what was going on when I first started playing.. but after many hours you start to get familiar with things and you learn more about the mechanics/ lore as time goes on.. which for me is one of the most important part of a game to keep me interested. Same goes for my experience with Dark Souls 3 (my first of any Soulsborne game).. It took some time and even some research to learn what all of the attributes mean/ what all of the items can do, etc. Near the end of the game I found it very satisfying to have a sense of progression in simply learning about the game.

IMO games that don't have you at least a bit confused or overwhelmed with how everything works will not have good progression or longevity.. especially RPG's.

On a slightly related note, I can get overwhelmed by the sheer amount of items/ inventory in RPG's. I loved The Witcher 3, but I couldn't stand the inventory system. There was an absurd amount of items but many of them just had different names (especially swords). They all look more or less the same but might have different names and slightly different attributes.. I found it to be a pain constantly sorting through all of the weapons and attire to figure out what to discard and what to keep. I also hated how the same weapons/ armor could have different strengths based on when you got them in the game. I think Souls games have a fantastic inventory system.. not an absurd amount of items to deal with but still plenty, and they all look different from one another and have unique abilities. Skyrim was very different, there is an absurd amount of items in that game, though I still didn't mind the system because most of the items were fairly easy to sort because most of the basic items will just have duplicates that can easily be sold or discarded without having to worry about accidentally getting rid of a powerful item. I also loved how you could craft your own items and give them a unique name.