I have a multiplicity of needs and tools. I'd rather have fewer tools, but nothing does everything I want yet.
I have a daily "life logging" practice that is a combination of work and personal items, including some "quantified self" stuff like when I woke up, how much I weighed, what I ate, etc., as well as work periods and tasks done or things accomplished, documentation of thoughts, feelings, ideas, etc. One of the reasons I got interested in Roam-like linking approaches is because it's a lot less work to connect my daily log to individual pages where I can analyze, etc. So now I can link to e.g. [[Weight]] and I have all my weight entries drawn straight from my journal, I don't have to actually open the page to add that day's weight, the "backlinks" feature shows them all for me just by linking. And that way I can read them in my more narrative journal too, without having to open a bunch of related pages to get the full picture of a day. Best of both worlds. That's just one example. Right now I do all of this in Roam, but plan to move either to Logseq or Obsidian, and maybe Codex long-term.
I also keep track of a lot of life, project, and activity stuff like Dormouse and Wraith. Pages for projects, entrepreneurial ideas, etc. I find the outline structure too rigid for this stuff, so I used to use Quip (and still have a lot of data in it), and have been slowly migrating this stuff to Notion. But not sure I like Notion enough to keep it all there... Depending on how well Anytype shapes up, I might be able to move the database stuff there.
Then there is regular data sets with some reasonable amount of commonalities, i.e. properties, that I want to store, sort, etc. Things like Recipes, Articles or Books to read, etc. These all go in Notion databases at present, they used to be simple lists or header-divided pages in Quip. The databases are better, but still not perfect.
Then there is the actual writing I do, mostly for planned blog posts (I say "planned" because I post them very seldom). This I do in Notion right now, it's the closest analog to a "web presentation" I can write in, and it's faster and better than working in Wordpress directly for me.
Ultimately I'd like as much of this stuff as possible to all be in a single system because interrelation and data re-use is incredibly powerful, time-saving, and useful. As a simple example, being able to reference the data in a property/field of a database from regular text, or link to a database entry in entirety from some other page (Notion can do the latter but not the former), etc. Or even embed a database record, or an entire table (Notion can do the latter, not the former).
That covers most of the non-work stuff. For work I chose and implemented Fibery, but that's getting pretty tangential to the topic of this thread.