I do some similar type stuff to what you asked about.
1. When entering the house, if the system is armed, the action of opening the door lights a path from the door you entered into our kitchen... it's the central part of the house with a huge island in the middle, so that's where we set whatever we're carrying.
2. If the kids get up in the middle of the night, it lights up a path for them - to the bathrooms though, not the kitchen - and alerts us in the bedroom (younger kids) - this is driven by contact sensors on their doors.
3. For the times in the morning when you leave, that's a simple timer - probably turn on at a certain time, turn off either when sunrise happens or when a certain time comes.
If you want to tie in with motion sensors, there's a couple considerations - if you ever want to use it for security, it needs to be a security motion sensor. The ISY should be able to detect those just fine. That said, they'll have a slightly longer delay. So - putting one that picks you up as you hit a staircase might not turn the lights on until you're 3 steps down - but if you put it far enough away, that 1.5 second delay can turn things on earlier.
I also use scenes to do a lot of this - I have a Snack Run scene that dimly lights the path all the way to the kitchen/pantry.