Narrow your results
One of the least attractive characters in all of opera is Prince Andrei in Modest Mussorgsky's Khovanschina. Here is a guy who is clearly sexually obsessive-compulsive but without the charm and complexity of Don Giovanni. He dumps his saintly fiance to chase after another skirt. She doesn't want him so he tries to take her by force. He is unconcerned with all the revolution and killing about him, even his father's, annoys the whole of society and never changes his selfish, boorish behaviour, even when being consumed by flames in the last act.