We have been throwing out a ton of self-built admin forms and CRUD pages by Airtable bases. Now people inside the company can add new fields, versioning by default, super simple interface.
Largest con: No webhooks. Which makes you pull data every X minutes to find out if a record changed. I would throw them a lot more money (280$/month now) if they just had webhooks as it could replace a TON internal systems/reports.
Second con: Ids. I would want them to support client delivered record_ids. Right now airtable has it's own ID field (which can not be set). Therefore if you want syncing to work efficiently you need to store that airtable_id on your side to do REST updates (PATCH). Would be better that airtable record_ids could be provided by the client so I can inject database primary keys and not have to store/query their record_id