Need a sensor recommendation for a metal door

That’s still a magnetic sensor even though it’s a different form, Unfortunately it’s not going to work on the metal door.

You can use the traditional box sensor if you lift it up off the metal surface and put it on a plastic or maybe a wooden block. But a lot of people don’t like the look of that. See the following thread for discussion of metal gates, which is a similar issue (this is a clickable link)

I do like the accelerometer idea if you’re OK with the looks and you can keep the sensor from getting smashed against the wall.