I don't think most people hate either kind of villain, they just want them to be well executed. Super tropey situations like love triangles or quotes like "I am your father" are popular because they can absolutely work. Conflicting romantic interest or internal conflict battling the fact that your dad is evil and you see yourself turning into him are fascinating, and can be worked into other stories well that aren't the first ones to do them.
For example, King Candy is a twist villain (aka he is revealed as Turbo) and a lot of twist villain haters use him as an example of a well liked Disney twist. When there is a clear purpose that the writers use a twist villain for it's exciting and jaw dropping, when it isn't purposeful the shock factor goes down and people just don't find the character interesting (like Hans from Frozen).
The same goes for the "normal villain," such as what happened with King Magnifico. He was promised to be the return to the fabulously, overdramatically evil villains that are pure evil just because they feel like it (this is an oversimplification, but it's what really draws people to them). There's not usually a sob story behind their actions, and if there is they blow their reactions to their past wayyyy out of proportion to the proper response because they are cruel and twisted. Magnifico was narcissistic sure, but the focus of his character was on EVIL without any flair or the super important part: the tension his actions place on the audience. For a good villain to properly work, we have to like the other characters or at least relate to them somehow. We can't feel lukewarm or bored, or else we won't care about what happens to them.
Asha says he's evil and sorta reacts like what he's doing is going to be terrible, but we don't see that to the extent we need to. The script really held both her and Magnifico back imo
Also sorry for the mini essay lol