I've only been pulled over once in my life. It was going into the queens midtown tunnel, aka, going from queens into manhattan. So yes, this qualifies as a NYC cop.
Going up to the toll booth, the cop was standing there, chatting up the tool booth lady. I probably should have picked another lane - you see, my registration had expired. The police officer noticed this and had me pull over. When he came up to talk to me about it, I realized I had lost my driver's license. I was flying frequently at the time, and had lost it in LGA. (I later got it mailed back to me anonymously after I had replaced it already.)
To keep this short, after explaning myself nervously, he let me go, no tickets for either my registration or lack of a license. There are some nice people out there. This counterexample to your nightmare NYC cops certainly doesn't mean there aren't nightmare NYC cops - there probably are. We just shouldn't lump all the people in any large organization into a single sterotype. There are good and bad - I tend to think there are more good cops than bad, but I'm not about to argue over the exact percentages. I haven't seen this site that was pulled down, but if it gave people an honest way to handle bad cops while not generalizing to every cop in the world, it was probably doing much more good than it was doing harm. People need to take things they read online with a bit of skepticism, and I think anyone reading a site like RateMyCop would realize that the people writing the reviews may have a rather large bias.