If you think about it, NULL is not a value.
It makes sens that it allows multiple NULLs.
If you don't agree, than your SQL point of view doesn't match the
majority, and your designs won't fit in the SQL paradigm .
I think it is just a matter of experimenting, and experience to see
how useful it is :)
hth.