I think there's several things to unpack.
1. Direction. I used to have this problem a lot. These days I pick a strong "theme" inspired by some other thing I really like (mostly Magic: The Gathering color wheel, but also a bit of Warcraft 3 since I picked up reforged) and that helps me stick to a direction, to a fault (where I hate extraneous party members who don't fit into my theme and am eager to replace them). If something else catches my eye, I just commit to doing it on another play through.
1b. Another thing that helped direction for me is that I created a self-goal of eventually having run a party with every single variation of a priest (preferably as mainchar)--because I enjoy priest classes. So it becomes less "which is the most interesting party I can build"--which can be overwhelming ("paradox of choice" or "prison of freedom" as you say)--and more "what is the most interesting thing I can do with this very specific, narrow constraint", such as "my main PC must be a priest/barbarian of some sort" (in this case I ended up deciding on a skaen/corpse-eater. Wasn't great, wasn't bad either.) For reference, I still have not done a single-class woedica, a thaumaturge, and a universalist. I may never get to universalist or SC-woedica; just not interesting enough.
2. Hoarding. This is hard thing to do, and part of it is influenced by game design; not a lot of games get item usage and consumable usage right. For Adra Ban, it sounds like FOMO. Again, if I miss out on something, I just commit to doing it on another play through. Having a strong theme in #1 helps, because I do a lot of advance planning on the Deadfire wiki unique items list (unique weapons, unique armor) and plan out which items I want the most, and plan to upgrade all the way.
3. Increasing your explicit knowledge. On top of reading high-quality information (not random ****posting about mechanics), probably a lot more experience and lots of q's asked and tests. My gamefaqs guide goes into a lot of details of the mechanics, but I feel like in all situations in life, you actually need to actually put the theory into practice to really internalize it. Even with all the stuff I've written there, and all the stuff forum members have posted here, there's tons of implicit knowledge about stuff and still tons of interactions yet to test. I think just more playthroughs will start giving you a sense of what interactions might be interesting, and what to look out for to test and to mix with.
YMMV. I've played Deadfire for 1000+ hours, and still am not sick of it. I think if you're fixated on getting just one run or two right, you may stress out more than if you just plan on playing however much you want to play, but that kind of long-term play commitment isn't for everyone (not even close). Over those 1000+ hours, I've made some parties that stunk and I didn't particularly like, and some that have been really great. Sometimes I've been playing and have already had ideas for three more parties to run. I don't run through all of them (some ideas I get tired of before I get to them), but I'm never too frustrated about doing something wrong or making the wrong choice. Plus, after 1000+ hours, I know most of the mechanics like the back of the hand, but even then I can still get surprised by new interactions just from chatting on the forums; it wasn't until hour like 900 that I tried a barbaric retaliation thanks to @Boeroer.
If you also just like cycling through a lot of parties, I don't think it's too big a deal to just do that. A lot of people have restartitis. Maybe eventually you'll find a party you'll take all the way. This was basically me back in the BG2 days - kept starting new parties until eventually I think my first PC that I finished was a random thief character after originally thinking I would want to play a bard or wizard (I ended up liking the thief experience so much I wrote a gamefaqs guide to the thief class). That was a surprise to me because I tend to be a caster person through-and-through, but something about playing a thief just happened to click in my brain that I ended up finishing BG2 with it. Maybe something similar could happen to you.