I would never use it any more, now that we have moved into our house and it's just us hearing the sound, but it would have been incredibly useful when we were living in apartments and our condo. It was SO annoying to watch movies with my hand on the volume control the entire time, turning it up while characters were talking, and turning it down during the action. I could never set the remote down. The problem was that we didn't want to disturb the neighbors, and the volume needed to hear conversations clearly would make the action sequences much louder than I was comfortable with.
So, in short, if I was still living in an apartment or townhome type place, I would demand a night mode on my receiver, but now, I would hardly ever use it.