Well where 2 hours into this and no-one mentioned org / org-roam, so I feel a begrudging responsibility to do so.

Org-mode is a combination of note taking, todolist, jupyter notebook, & calendar major-mode for Emacs. It is wonderful and terrible in a lot of the ways emacs itself is. It is incredibly configurable and extendable, and feature rich to the degree that discovering spreadsheet support after using it for 6 months seems to be a rite of passage.

Org-roam is an extension ontop of org-mode that creates an roam like layer.

The largest drawback stems from it being so flexible making it hard to develop a good phone client for it. Through Álvaro Ramírez's PlainOrg(iOS) & Orgzly (Android) do help somewhat.