That's fairly common, most banks have "overdraft protection" that works exactly how you described.
I'd agree with the idea of avoiding overdraft entirely unless a customer signs up for it. I don't want transactions I can't afford to go through. I manage my accounts quite closely. For me such situation would be 99% an unintended transaction that I would like to cancel.
By letting such requests go through, banks put the burden on the customers to clean up after a wrong or, in many cases, illegal transaction.
YMMV.
I had a bank charge me an overdraft fee. I asked them to show me my overdraft authorization.
It's amazing how fast a bank can return money when they screw up.
That's because it was automatically enabled by default. This is what banks would do if they weren't predatory.