Here is the thing though, a ridiculous motive does not make the villains bad, the story not showing the flaws in their logic does.
I don't have a problem with villains with silly and stupid goals so much as I have a problem with the story trying to paint it as if they are making a lot of sense, or just forgetting to have an actual ideological battle, as opposed to just a physical one.
I have seen plenty of ridiculous motives in villains, and they are not dealbreakers... Hell, one of my favorite villains of all-times, kefka from FFVI, is just a nihilistic bastard who believes nothing matters so it's ok for him to just destroy the world and torture and kill people,
But in that story the group bands together and overcome their fears and traumas, and eventually confront him ideologically, shutting down his nihilistic worldview BEFORE engaging in combat after he throws a tempter tantrum about being talked back to.
A good villain can be flawed and not make a nick of sense, downright deranged, so long as you don't try and make me feel like they were this 'profound' misunderstood genius... If you want me to care about the villains agenda (and eventual downfal) the heroes need to care about it too, and engage in his discourse, point out the holes in his plan and the horror of their ways, and all that before the big climatic showdown (or even come up during the battle).
That way we don't get any new Thanos's out there who went to study phylosophy and quit after the first two classes thinking they had figured out the universe.