I understand where are you coming from and the anxiety embedded in the question about the “one-in-all-tool” solution. I have asked myself the same for a long time.
Well, this is not meant to upset you but the answer is that that tool doesn’t exist. Everyone has a different working style and every app/tool has some strengths and weaknesses. Even within the same software class “note-taking” there is a huge variety of applications, features, UIs etc. I wouldn’t use 95% of the note-taking app out there, for example. This is to say, you should look for the unique combination between your working style and each tool features.
To give you some concrete example, I have a pretty sophisticated system in Notion which I use for high-level project management and daily execution. In Airtable I store things like photo, books, pdfs, in general stocks of resources and reference for my job or interest. Finally, Obsidian is where everything get distilled and expanded - in theory, because I’m just starting out here and feel a complete rookie.
But this is the system I have conceptualized,3 tools overall not too bad and believe me I feel way more empowered and on top of things then when I was trying to pack everything into Notion.
Look at the intersection of tools functionalities, your working style and tools preference.
Hope this helps.