My verdict: the open-source alternative to Fivetran that changed the game.
Airbyte has become my default choice for centralizing data in a data warehouse. 300+ connectors, self-hostable, and pricing that won't ruin you when you scale - it's what Fivetran should have been.
I use it to sync CRM data, product metrics, and advertising data to BigQuery. The initial setup requires some technical skill, but once in place, it runs.
What I like less: it's clearly oriented for technical profiles. The UX is improving but remains below modern SaaS standards. And self-hosting requires real maintenance.
My advice: if you're building a data warehouse and have an ops/data profile on the team, go for it. If you're looking for plug-and-play without technical skills, look at Fivetran instead (but prepare your wallet).