I'm firmly in the second category. I want my room to be as dark as possible while I'm sleeping. I don't have a night light right now, but if I did, I would get something that errs on the side of not being lit. For example, a motion-activated one.
If that is what this dim by default behavior is intended to accomplish, then it sounds like a wonderful idea to me. A night light is a hard sell for me in the first place, but this is the sort of thing that might convince me to consider it.