Help: Is Airtable right for me?

I’m looking to build a B2B real estate web app that internal folks can upload information to (photos, videos, plans, and text data) and also create private surveys for external clients can review and also comment on (for their own teammates and/or my team). Clients should not see each others info, but they also won’t have seats as part of my org (ideally they log in to a front end on my site or they get magic link). We currently have 50-60 new unique external users per month and hundreds of existing so the solution needs to scale.

A few folks I’ve spoken to have pointed me to Airtable + Glide but long term it gets expensive. Others have suggested building something outside of no code.

Would love this community’s feedback and guidance.