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.