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.