If you are looking for a self-hostable Notion alternative, I am building Docmost, which is open source.
It has real-time collaboration and support for diagrams (drawio, excalidraw and mermaid).
It can be tempting to want to do it all, but I am focused on building a great wiki and documentation software.