>>96311236
Your players should love to hate them. If your players enjoy the villain showing up, then you're doing your job right.
If you want to know how to do a good villain, go watch Kamen Rider. Go watch kamen Rider Build. Just make all your villains Evolt. Cunning, scheming, sometimes even helping the heroes against lesser threats if it suits their own ends, and ultimately absolute, utterly mad and reveling in their evil. Double points if they start pretending to be an ally and reveal their evil nature through the players uncovering it while investigating another mystery.