This has been my experience with internal tool builders too. The barrier to entry is quite high to try most of them and it's really hard to have a whole team test them out.
This adoption issue was part of the inspiration for Wax [0] which lets you build internal tools on top of Google Sheets. If your team is already using Sheets, it's much easier to add the missing pieces there vs. pushing people to an entirely separate platform.
In noco we've the concept of primary-value (like primary key) and that shows up automatically when you join with other tables (defaults to 'title'). However the primary value column can be changed to any other column too (by hovering on the column name).
Other tools in the list do not give the smart-spreadsheet automatically when you connect to databases. And frankly, these are two different tools we are comparing.
This, for me, was easiest to try out. And quite impressive, honestly.
The key point was that in each table, the 'title' column (created by default) has a special meaning as they show up in the join columns cleanly.
Amazing and congratulations.