Learn English – A word that means ‘hateful but indispensable’

Misanthrope: defined by Merriam-Webster as "a person who hates or distrusts humankind." It may be too broad for your need, but if you mean to say that the person harbors an angry, resentful hatred for his/her fellow man/woman, this word might be what you're looking for.

might the word be evocative: bringing thoughts, memories, or feelings into the mind; evoking or tending to evoke an especially emotional response.

1. "so evocative that they bring tears to the eyes" — Eric Malpass.

2. He wrote a powerful and evocative biography.

3. the Italian-American restaurant is decorated in a manner evocative of the charming outdoor cafés in Italy.

adverb: evocatively.

noun: evocativeness.

Synonyms: suggestive, reminiscent.