I do otherwise employ the workflow you mention: automatic downloads and supervised but nearly automatic imports.
For importing: https://github.com/jbms/beancount-import For downloading: https://github.com/jbms/finance-dl