Yes there are modern banking solutions like this (we have instant transfers between banks with a comfortable QR scanning app just like google pay here in Switzerland) but this only works in Switzerland. For any international transfers we have to fall back to Swift transfers (slow) or credit cards (mentioned issue).
Yeah you can do that exactly with a debit card - just ask your bank to remove the spend limit and give you zero overdraft.
Once you realise effectively you are describing a debit card with less options then suddenly it doesn't look like such a good feature.
But now we are specifically just talking about international payments where you explicitly don’t want any currency conversion or buyers protection, and the use case is just getting farcically narrow.
Or a credit card with spending limits?
In the U.K. with banks like monzo you can also raise/lower the limit instantly via an app. Also the fraud detection algorithms will automatically ask for 2FA on larger transactions or ones that look fraudulent e.t.c.