A Notion property is a suggestion. A date column accepts text, a number accepts a dash, and nothing stops somebody typing “TBC” into the field every report depends on. The errors arrive months later, in a total that is quietly wrong.
Properties are mapped to real field types on the way in, so a date is a date and a number is a number. What cannot be parsed is visible immediately rather than in a figure nobody re-checks.
Rollups and relations work until they matter. They are per-view, they recompute lazily, and past a few thousand rows the page that is supposed to summarise the business becomes the page nobody opens because it takes eight seconds to paint.
A rollup is computed by the database, over every matching row, and it is the same number in a grid, a report and an export. Size is not a reason it stops being usable.
The database is inside a page, and the page is inside a workspace nobody can query. There is no way to ask one question of six related databases, so the answer is assembled by opening each one and reading.
Imported databases are ordinary tables. Link them for real, then ask across them, and keep the answer as a report rather than as a ritual.
Everything downstream is manual. A row reaching a state means somebody notices and does the next thing, and that process exists only in the head of whoever usually does it.
Rows are records, so they can trigger work: the chase, the notification, the status change, each in a run log you can read afterwards.