Zee M Kane

Hey everyone! I'm a fitness blogger and podcaster. I love to hike, ski, and travel.
Are they plans to make it possible to override the theme for one specific site? i.e. my Notion is not in dark mode, but I'd love my site to be.

And also any plans for custom themes/CSS?

Yes! Enforcing dark mode will be really simple once we launch the Static beta early next week. Will revisit next week. Custom themes are definitely on the horizon too, got some cool ideas for that. We'll be spending more time on Super going forward, so we'll be pushing out feature updates more frequently.
The site I'm looking to build relies on linked databases/galleries etc. Will they work with the static site feature you're working on? Thanks.
Yup - will work perfectly.