I'm using Notion as the DB for a simple jobs site with a static frontend and it's been really nice. Super easy to use CRUD interface out of the box and it's easy to rapidly iterate on data models.
Normally I approach these kinds of projects with a well planned out data structure and proper migrations but the velocity in getting something usable out the door and getting people to use it as been well worth the shortcut. I hope Notion leans into this use case.