Obsidian is on a fundamental level a very different app to Notion (you already mentioned the web app, databases, ...). It is also not even close to being "hackable to the core", it is not open source. That title belongs to Emacs.