I have been dying for this. Currently I use privacy.com and their spending limits to get the most basic of functionality. I would my bank to provide an API and make this type of control and other information available. Maybe I could really dream and it would be standardized across banks.
Wise lets you access your account and money with API-s. You can create a personal token (and webhooks if you want) at https://wise.com/settings and you're off to the races. Api docs are at https://api-docs.wise.com