I agree. Integrations can be incredibly cumbersome if you have to learn each API from scratch.
There are also more flexible solutions like https://www.nango.dev
It handles the API-specific complexities (auth, retries, webhooks, per-customer config, pre-built templates) but allows you to implement the exact use case + data model you need.
It's open source/source available.
(disclaimer: I am a founder)