I think it really depends on your motives. Being not-nice, if it is done intentionally so as not to "condone" his drinking is really a form of manipulation. You're trying to punish him, to show him that he's been "bad".
If you're being nice so as to make your home pleasant for you and you're children, I see nothing wrong with being as nice as you want to be. It takes a lot more energy to be hostile than to be pleasant.