I have this obsession with playing optimally at the highest difficulty level. So I have to collect every resource, craft all the best items, etc.
But collecting all that stuff is actually quite a tedious click-fest in many modern games like D:OS2. (Dallas' bedroom on Lady Vengeance is a prime example.) And it requires going to every nook and cranny of the world map.
So I can't stand leaving anything behind, and I'll never end up using even half of it, but what if I do need it and I don't have it later on?
I've been playing Cyberpunk 2077 recently, and I don't have that problem with this game, though the solution may be unsatisfying to many. I've already hit max level on everything, and upgraded everything that I can. There isn't that much loot in the game in general (each mook has one or two items), and that can be quickly picked up and broken down as needed. I have more money than things to spend it on.
So I spend my time exploring the world rather than managing the character's inventory.
The Nintendo Switch Zelda games also do a pretty good job of balancing all the inventory / crafting. The resources regenerate (fruit trees grow more fruit over time) so it isn't necessary in most cases to try to grab everything whenever you see it.