I'm willing to give it a try. My biggest beef with Night was when he did The Last Airbender movie, because--well, in a nutshell? He screwed everything up. The pronunciation of names, characters' personalities (which came across like cardboard), the obvious cultural affiliations between the Avatar world and our own (anyone who's watched the series can tell you that the Fire Nation was predominantly modelled after the Japanese, the Water Tribes after the Inuit, etc.)
The list goes on.
That said, I didn't mind Unbreakable or Signs, though they aren't movies I watch often anymore. Sixth Sense was alright, but for some reason it just never wowed me. Funny enough, I own Lady in the Water, but have yet to watch it; too many movies on my shelves. ^^;
All in all, Night may not be the greatest movie director, but his work isn't the worst I've seen, either. I'd rather judge his works individually, than assume they're either all **** or all great just because his name is attached to them.