'Sex and The City' was made to correct the myth that if you were single at a certain age, you were a leper. Its four characters are heroes to a lot of women; they run around New York, or Gotham - but they have fancy shoes instead of capes.
It really doesn't matter whether it's the villain or the hero. Sometimes the villain is the most colorful. But I prefer a part where you don't know what he is until the end.