In stark contrast to those 2 examples of Notion and Figma, consider Obsidian. With its massive OSS plugin ecosystem, it approximates their combined capabilities, but has a foundation of offline-first, local markdown files.
In what world does Obsidian come even close to having any overlapping features that Figma has?
This one, the real world, where Excalidraw and Canvas in Obsidian provide a fair amount of overlap with Figma.
Honest question from someone who’s never used obsidian: Does obsidian have anything like Notion’s multi-view databases?
TBH I'm not sure; I used Notion for a few months a couple years ago but unsure about "multi-view dbs" in particular. But I will say, the breadth and power and extensibility of Obsidian w/ its massive OSS plugin ecosystem is hard to overstate. If you like a Notion feature, I'd bet heavy it's doable in Obsidian.