These days, I've left both traditional and roam-like note-taking apps behind because they all left me with collections of half finished notes on ideas/writings that I would seldomly revisit again. Instead I started to just use Anki for all my note-taking. It's not made for this use case, but it is part of my daily workflow anyway and it solves my biggest problem of stale notes by making me revisit them regularly.
With Anki I record any fleeting ideas as standalone notes, without an "answer" component. Later, when these note come up for review I spend a few moments to refine each idea. This keeps the notes dynamic and evolving. If the idea turns into something promising, I'll add an item on my normal ToDo list for some dedicated in-depth exploration of this idea. Conversely, if the idea seems like a dead end, I'll suspend it so it is not shown anymore during review.
The feature I'm missing most is being able to easily link to related notes. Anki's notes can be grouped into decks, and tagged, but I find jumping to the note browser and entering search terms cumbersome.
Example of the note-taking workflow: I have an idea of an Anki feature which would automatically link related notes to each other, and e. g. show the links at the bottom of each answer card. I suspect that text embeddings could help there. So I add a note "Using text embeddings for automatic Anki note linking" to my Ideas deck. The next time this card is shown during review I might edit it to add "Implement as an Anki plugin that will regularly run on and update all notes in the collection" and the next time maybe some thought about an implementation detail like "? how to make sure that the links it placed in the note by the plugin are ignored for embedding purposes".
Thank you for the retroactive feature request!