I've been listening to different All the Evils of the Worlds for some time now. Inspired by both Kotomines from different Fates, I create anew another in their visage. This villain will recreate the Biblical Flood via Ten Plagues, Tower via Salt, Purgatory, Hell, and Paradise on Earth, People, Heaven. The plot device enables him to do all miracles and judgments. The motive of this villain? Selfishness. He is selfish, because only he wants be to noticed by the Throne. He desires that his salvation comes first. His plan to make the Heavens see, hear, speak only him? Massacre. Like the Heavens, he too shall commit massacres on Earth towards the People to reach Heaven. Flood the World with conceptual attacks that originate with Sin. Build the Tower of Earth from the remains of People to reach Heaven. Purgatory will be his house. Hell will be his backyard. Paradise will be his apartment. To make it more understandable, his idea is to be the most sinful existence there is, so that the Throne will notice him, touch him even, and personally save him from living the life of a sinner. Again, he is selfish beyond reason. His Hell is the true hell, because plot device. His Paradise is the true paradise, because plot device. His Earth is the starting point with all Earths from other Worlds to be Flooded with Sin, and the Tower shall exist only in his Earth, because plot device. Though he is a villain, he is not insane, cruel, or emotionless. He delivers the good People to Paradise. He delivers the bad People to Hell. He delivers everyone from Earth to Purgatory to fuel the Tower made by Salt to reach Heaven by Flooding the Worlds with Ten Plagues.
Forget villains with superpowers. Mama from Promised Neverland is the best villain. She is truly memorable since you sympathize with her.
Thanos is the perfect villain. Just as an example. People are not evil because they want to be. Selfish assholes are bad, yes. But the worst atrocities are always commited by those who think they are right. The road to hell is paved with good intentions. Make the readers understand his point of view. Why does he want to do this. What caused him to change to this abomination? As to your villain... i wouldn't call him anything but mediocre from your description. Also he is quite insane.
If you can make the readers not only understand their motivation but also force the readers to choose the same path if they are in the same situation, then that villain would be memorable. Make a good backstory, show us why he became like this, or show us why he acts like this.
The perfect villain is the one that best suits your story. You wouldn't use Thanos as the villain for a murder mystery for instance. If you write a story about prim and proper ladies, the perfect villain might just be a woman who plots and schemes to have the main character embarrassed or discredited.
A good villain isn't overbearing and is relatable to the reader, and can make the reader question their own morals and philosophies as well as converting a couple of the readers to support the villain over the hero.