Well, in our (certainly far from special) home:
10 second fadeout - all our light switches, tap once to fade on/off, twice for immediate on/off, hold to manually dim, same for the remotes.
Porch light - comes on when it detects movement, stays on 30 seconds after movementhas stopped.
Garage lights - come on when the door rolls up. Admittedly, there's a transponder in each car which opens the door as you approach, but hey, if you heve to open a double roller door manually once, you never want to do it again!
Smokealarms - built in lights which come on when the alarm sounds, one at each end of the house and one in the middle.
Doorbell - bloody loud, intercom screen turns on to ahow you who's there
And all of this with technology built into the house in 2004, probably at a cost no higher than the $1,000 or so it would cost to put a 'smart' light bulb in every room, and not an internet connection to be seen.