Interesting Article,

At the end of the day we are providing workable and maintainable solutions to real world problems and have to strike a balance between idealism and practicality. If a solution warrants the use of NULL then use it appropriately, if factoring out into another table makes more sense do it that way.

Mike, I think you nailed it in your conclusion:

"learn how to use them properly, and minimize their use where practical."