Can you say more about how you use Airtable? To me Airtable has a really appealing low/zero startup cost, but then I'm always tripped up by not being able to do arbitrary queries, joins, etc. to create new views.
I use Airtable for "quantified self" type things like logging workouts and health metrics, also tracking reviews of books and movies, planning travel, and anything that I would otherwise use spreadsheets for.
By the way, you can do simple joins in Airtable by using the "lookup" and "rollup" field types, but I agree that it is relatively limited in that respect.