Adding my own to the list: https://github.com/superegodev/superego (Warning: still an alpha.)

Distinctive points:

- It exposes the "database metaphor": your data is organized in collections of documents, each collection having a well-defined schema.

- It's all local in an app (no server component to self-host).

- It has an AI assistant on top that you can use to explore / create / update.

- It allows you to create small personal apps (e.g., a custom dashboard).

- It allows you to sync data from external sources (Strava, Google Calendar, Google Contacts.)

Cons:

- The database metaphor is quite "technical". A "normal" user is not comfortable with the idea of creating their own collections, defining a schema, etc. In fact, right now I only have developers and techies as a target audience.

- It's not optimized for any one use case. So, for example, as a notes-keeper Notion is obviously much better.

- It's still in early stages (I'm working on it alone), so:

  - There's no mobile app yet.

  - It doesn't yet support syncing between devices.

  - There are just 3 connectors to sync from external sources.