Even though this is true, there can still be a lot of value in certain scenarios.

For instance, this is why I use GraphQL strictly in my admin backends. Exposing the database almost verbatim through Postgraphile as an Express.js middleware. All data is now trivially accesible. Everything that requires custom resolvers or other complex customisations are handled over a Rest endpoint. I now have all the benefits of GraphQL without the complexities you face when moving into more edge case scenarios. In pretty much the same way I use Prisma ORM but raw queries for anything non trivial.