That doesn’t have to be the case. Take Farscape as an example, they had fantastic main villain in that show, and you could very much understand his motivations, and even find him relatable in some ways. Yet, it didn’t detract from him being a villain and having some of the best writing.