Really nice writeup. And I will concur that the automations are super useful. I'm blind as a bat, and having dimmed passage lights come on when I stumble out of bed at 2AM has saved me from many a fall (3 cats provide plenty of obstacles).
I have one of those SleepIQ beds, and fortunately there is a community cloud integration available in this thread.
Your local integration is much nicer though.
