It always blew my mind that services like Yodlee (https://www.yodlee.com) worked that way. I can understand it from the point of view that no traditional bank was set up to allow structured access but it never felt right to me.
In the UK there is a big push around "open banking"[1] which will bring this into the 21st century and allow for proper programmatic access to data. It's still in it's infancy but the sector here is transforming around it.
[1]: (https://www.openbanking.org.uk/customers/what-is-open-bankin...)