You could use the Universal Device Type Handler as a contact sensor that triggers your alarm and then use Smart Lighting which runs locally to turn it on with a secret button press.
For cellular backup, you could replace your current WiFi router with the PepWave Surf SoHo 4G WiFi gigabit router. If your cable internet goes down it will automatically switch to 4G cellular internet. You can get cheap pay as you go LTE plans for as little as $3/mo from H2OWireless.
For battery backup you can get a UPS to keep your cable modem, router, and SmartThings hub up for a few hours.
But that still doesn’t address the SmartThings reliability issues. SmartThings doesn’t always arm and disarm at the right time, lots of false alarms, etc. Commands not being sent/received. This is all sporadic and doesn’t happen to everyone, but it is enough that if you feel you need a 24/7 alarm system, ST probably isn’t for you. If you are OK with the occasional glitch or false alarm, then maybe ST will be OK for you.