This is a very US-centric question and answer.
Don't bounce payments. Use credit cards for that.
and some automated monthly subscription I've forgotten to cancel comes through, I'll be charged an overdraft fee
Because bank accounts require more personal responsibility than credit cards. The overdraft fee is the "lite" punishment for bouncing charges. The "heavy" punishment is a 7-year ban from using banking - you become one of "the unbanked". If you wonder who uses those weird pink neon check cashing stores, it is the unbanked.
The punishments are fierce because bouncing checks is serious business. Also, the bank is providing you a service - for that $39 fee they're giving you overdraft protection in many cases, paying the charge anyway and letting your account go negative for a few days.
You should treat your bank accounts with a certain amount of respect and fear.
For this use-case (e.g. monthly subscriptions), you should be using credit cards, not bank account debit. Credit cards are specifically designed to use the way you are trying to use it - charges that will have no consequence to you if they are declined.
Further, credit cards provide vastly better consumer protections in all sorts of ways, which suit themselves well to a person like you who isn't necessarily always on top of everything. (like me too, no judging here).
Even if you don't have good credit, seek out a deposit-type credit card, where you give the bank $500 cash and they give you a credit card with a $500 credit limit. Don't use "prepaid visa/mastercard gift cards" like you buy at the checkout lane at grocery stores; they have many gotchas and most subscription services won't accept them anyway.
"Unsubscribing by breaking payment methods" is a dumb idea.
Because most banks and credit cards will do their level best to make sure trusted services like Netflix are able to continue charging, even with obsolete card info. Why? It saves them millions in customer support costs.
If you want to unsubscribe, the absolute best way is to log onto the service, and use the "unsubscribe" feature (at the risk of stating the obvious). It also helps to delete all your payment methods.
How to untangle the mess
Actually, I'm doing that right now, because I am wrapping up an estate which has many automatic deposits and debits in/out of its bank accounts. Easier for you, you have all the passwords to those services lol.
The key thing, I'm guessing you either trash all your bank statements or did paperless and never look at the statements. OK, it's time to look at them.
- Log into your online account at the bank (I gather you have one; if not call bank CS and create one).
- Pick the checking account in question.
- Look for "Statements".
- This will give you a list of all your monthly statements going back 10 years.
- Click the most recent statement, grab a note pad and write down every charge. Especially if it looks like a subscription service.
- Click the previous statement, write down any charges you haven't already seen.
- Lather rinse repeat, with every statement going back 13 months. That will catch annual subscriptions.
For each of those services:
- Log in.
- Go to "account / payment methods".
- ADD a credit card payment method.
- Very important: DELETE your bank account payment method.
You need to delete the bank method, because if your primary is declined, many will automatically try every other payment method in the system until they find one that works. Deleting the payment method is the only way to stop them doing that.
How to close a bank account
There is no law that says to open an account, you must close another. You can have as many as you want. In most cases there is a monthly fee, but that is the only downside.
So, you move most of your money out of the old account into your new account, and start doing all your business out of the new account.
But leave enough money in the old account to cover a couple months of your automatic debits. If there's a minimum to avoid fees in the old account, and you can afford to leave that amount there plus a bit for charges, then do so.
Labor as I described above to identify and move all your periodic charges.
Check your old bank's statement every month. When you get 1 statement that was quiescent (no activity except for a monthly fee), then go into the bank, see a banker, close the account and take it in cash.