IVB - are you understanding what others are describing for local load control? For example, I have a desk lamp on my desk that's on a UPB appliance module - it can be controlled by a UPB switch by the door (next to the one that controls the overhead lamp) but if I'm sitting at the desk and want the light on, all I do is reach over to the lamp's on/off switch... presumably the switch is already set to On but it's turned off because the lamp module is off - however, if I reach over to the lamp's switch and flip it off then on again, the lamp module detects this and turns the lamp on to the predetermined level. There's no reaching for the appliance module or getting up to go to the switch. I use this in a few rooms in the house.
As others eluded to, of course you can always use some palm-pads. Depending on your technology, I use UPB for instance, so I have a W800RF32 connected to Elve so I can use some of the palmpads around the house. One example is in my daughter's room - the rocking chair is right next to her lowboy dresser - and on the corner is an inconspicuously mounted keypad (the one that looks like a decora switch but is adhesive backed and super thin) - so while sitting in the chair, I can turn off the overhead light, turn on her table lamp at 30%, and turn off the hall lights outside her bedroom - all without getting up.
The local-load switching also works well with normal table lamps - the kind with the turning knob up by the lamp - people barely even realize they're turning it twice instead of once (kinda used to it from the 3-way bulb functionality of the switch). The real rub comes when they turn it off manually, but I use a few real-handy all-off functions... one to kill the whole downstairs from outside the master bedroom (my main reason for going nuts with automated lights after having to walk around to 15 different switch banks on my way up the stairs) and another that kills every light in the house as the system arms, so when we run the kids to school all their bedroom/bathroom lights are taken care of, and when we head upstairs for bath/bed, all the downstairs is taken care of - it's all quite convenient.
I don't bother automating much for lights coming on - my wife and I are very manual people and it's hard to predict at any given moment which mood we're going for.