All games can’t be all things to all people.
Especially with edgier content like sex or violence, writing to appeal to a certain audience can limit your fans who don’t match that profile. If you write a game where you can play an absolute monster, some people will buy your game specifically to play as a villain, while others would seek out a game because the only options for player characters are heroes.
I think it’s mostly about writing what appeals to you, doing it well, and describing to people what they’re getting into. If it’s a dark, edgy escape fantasy about being a criminal mastermind, that’s how you should pitch it to appeal to the players who will enjoy it. If it’s a light-hearted game where you play some variation on an essentially well-meaning character, describe it that way and people who enjoy being a hero/everyman/not a jerk will know to play it.
As for me, personally? I don’t think there’s currently a game by COG where you can play as evil a character as I would like to - I’m a Joker fan, after all. But I’m an outlier. (Granted, outliers can still have money and buy your game.)
Paranoid, violent people can still be effective leaders. They just need to bring something significant to the table to counterbalance it. Handsome Jack is a great example of a character who makes random murder of his underlings work for him, to promote an uneasy and disorganized workplace that will never be able to function without him. Some historical leaders have used similar strategies to get ahead.
Sorry, I’m digressing here: to get back on topic, there are many ways to be a jerk, and they don’t have to be unproductive. Some people might respect your character more for not being a goody two-shoes or a “hero” - not everyone believes in idealism, law and order, or any other value you could name.