After trying all the banks, the only bank that opens a checking account with a tourist visa is Bangkok Bank. They required me to take out accident insurance the first year.
They include a debit card for payments in stores, online purchases and free use of ATMs
Any Bangkok Bank branch in Pattaya will allow you to do this, and the conditions are the same in all branches: Beach Road, 3rd Road, 2nd Road, etc.