I just had to get in on this one.
I tend to play CN characters, of which no two are alike. Not one of them can be termed "crazy," "disruptive," etc. I have been known to throw out a concept I loved because it didn't mesh with the other characters in the group and start up a new one. CN gets a bad rap because most of the people who play it either a) don't understand what it means or b) don't care about everyone's right to have a good time at the gaming table. CN is NOT inherently flawed.
It took me a while to convince my husband of that when we first started gaming together, but I managed to get him to let me try it for a couple of sessions. Kandira Quick-Fingers is still fondly remembered as a child-like kender who made Ravenloft very interesting for the party at large, and the elven archer in particular.

The party took shelter for the night in an inn, but heard a baby crying. They had been warned to not open the doors after dark. Kandira couldn't help herself; she just HAD to check on that baby and rescue it. She opened the door only to discover a leucrotta on the other side of it, having dodged the archer's grab for her. She immediately slammed the door shut, exclaiming "That's NOT a baby!!!!" The archer (I can't remember his name anymore) picked her up by the scruff of her neck and made her promise that she would not open the doors again after dark. She agreed. That was a promise she kept through the rest of the campaign.
As you can see from my example, CN does NOT have to be a pain to DM for or to play. It's up to the player to decide when to curb the character's potentially disruptive tendencies in the interest of enjoyment of the game. As for the player who insists on screwing with everyone and anyone...another CN char of mine fried the CN char of a player who insisted on playing it that way, and the player was stuck making a new char.
Husband (and DM) here: I blame 2nd edition's wonky alignment descriptions as well. In 2nd ed, I was one of those "No evil or CN PCs." The above kender example was one of the first I allowed. With the advent of 3rd ed, and the more reasonable alignment descriptions, CN has become much more common in my campaigns (mostly my wife's characters, but, hey, who's keeping track

)
Marie and Quentin