> Back in the day they were only for ATMs and very few businesses.
That was pretty much specific to German-speaking countries (or at least they were the only one, where I noticed that). Elsewhere, there was no such thing as ATM-only card (or even ATM-only PIN).
Yup. Visa Electron and Maestro are quite normal debit cards. I have one of those as well. Apart from renting cars you can pay for just about anything with it. Maestro has an ATM withdrawal fee even when you use it in the emitting bank's ATMs, which is a reason why I avoid it like the plague.
Don't even exist in many places anymore. e.g. in the EU country where I live both were replaced ~8 or so years ago by Visa/Mastercard Debit (since they removed embossed characters the only way to distinguish them is the word 'debit' written in a tiny font.