I can recommend you Zettelkasten. I actually wrote software for myself, in my opinion you get the most freedom that way and second brain should be custom tailored for you.
New software that is getting praise right now is Roam Research, but I haven’t used it