I love threads like this that really get me thinking and typing a lot.
Team Rocket – A straightforward criminal organization or Pokémon mafia of sorts that was motivated by money, had several resources that allowed them to create artificial Pokémon in labs that brought us Mewtwo, and had no qualms against killing Pokémon, such as the Marowak in Lavender Town. They had a skilled, feared boss in Giovanni that was good enough to be a gym leader and a top battler in Unova as well. They're also very iconic because of Jessie, James, and their talking Meowth in the anime. Team Rocket was everything a villainous team needs to be in Pokémon, hands down. However, their main issue is that they are extremely incompetent in every adaption they appear in, which is actually, I would say, part of their charm.
Team Magma/Team Aqua – An organization driven by science, but unfortunately, full of people that were unqualified to be scientists. Albeit they had positive intentions, such as Team Magma wanting to bring the world more sunlight under the belief that it would help people, and Team Aqua wanting to bring the world more water under the belief it would help Pokémon, they didn't understand that using the power of Groudon and Kyogre to fulfill their respective goals would threaten the health of the world. Because of this, I think they weren't among the brightest of the villainous teams in Pokémon. Archie was more of a brute and while Maxie was likely more intelligent and calculating, he still failed to understand how his plan would fail miserably. Other than that, they're actions did make for a really good story, which saved them from being bad.
Team Galactic – I have to disagree with you about this villainous team being generic. If anything, they are arguably the most dangerous of all the villainous teams because they're arguably the most competent of all of them. Unlike Team Rocket, who could easily have their plans be foiled by different children in different continuities, Team Galactic was the closest to actually fulfilling their goals. Cyrus is an absolute madman that took villainous teams to the extreme by wanting to destroy the current world and making a new one, all while expressing little emotion because he's been mentally broken since childhood. This doesn't sound like Pokémon. This sounds like Armageddon. Team Galactic actually succeeded in their plans of kidnapping the Lake Guardians and using their power to put their plans into motion. Cyrus literally almost destroyed the world right then and there using the power of the main legendaries, but it was mainly Giratina that stopped him, along with the protagonist.
Team Plasma – An organization that was perhaps the best in my opinion, mainly because of how cunning they were. Just when you thought that Cyrus was a complete monster, they one-upped him with Ghetsis, the guy that has no qualms against killing children and abusing his own children. What made Team Plasma so dangerous was that they hide under the façade of being a good organization that believed Pokémon training was bad for the Pokémon and wanted to free Pokémon from their trainers for their wellbeing. However, that was only a rouse to take people's Pokémon from their owners so that they could use them for world domination, and it almost worked until the player stops them. They had believable intentions, well-developed characters, interesting characters such as The Shadow Triad, and they made for a great story. Ghetsis was utterly ruthless, well-written, and was one of those bad guys you wanted to destroy and not felt sorry for. I wish we had another villainous team like Team Plasma. N was also a great character as well. His story moved me emotionally. It brought tears to my eyes, but also brought me motivation.
Team Flare – Even though they might appear to be a team of fashionista goofballs that can't be taken seriously, lowkey, they are actually quite competent than they appear and they are utterly ruthless as well. Their leader, Lysandre, is, in my opinion, not much different to Hitler. However, instead of extreme racism that he promotes, he pretty much replaces racism with "beauty" and similar to Cyrus, wants to destroy the current world and replace it with a more "beautiful" one. This makes Lysandre a complete nutcase, as well as those that paid 5 million Poké Dollars to join and support him. If you look past the goofiness of the group as a whole, they all really come off as Nazis. Like Team Rocket, they have several resources that allow them to make several machines and weapons in labs and they too almost succeeded in their goal of unleashing the Ultimate Weapon to destroy the world. They even had one admin, Malva, serve as a member of the Elite Four, proving they had great battlers on their team, and as a newscaster, proving that they were well-organized. Despite them mostly being goofs, I commend them for actually posing a threat that needed to be taken care of immediately.
Team Skull – This is where villainous teams really started to become jokes in my opinion. They were a street gang that was formed out of people that failed their Island Challenge, resulting in them devoting their time to disrupting the Island Challenge of small children, ultimately existing on nothing more than being petty. However, they were so incompetent, they couldn't even succeed at being petty. In fact, their incompetence level was worse than Team Rocket's incompetence level, which is saying something. They had ridiculous poses and dance moves that made them hard to take seriously and they very rarely, if ever, posed a serious threat to anything. In fact, most people in Alola weren't even afraid of them, instead viewing them as complete jokes, which they were. While I definitely wasn't a fan of Team Skull, I was a big fan of their leader Guzma, who I thought was a great character. He had a lot of personality, great battling skills, and he revealed that he wasn't all that bad of a person either. I liked their second-in-command Plumeria as well, as she wasn't a dancing/posing goofball like the grunts, was more mature, and had a big sister mentality.
Team Yell – I don't really have much to say about Team Yell other than Game Freak somehow found a way to make a villainous team worse than Team Skull. I don't know how they managed it, but they did. Oh wait, I think I know how they managed it. They basically didn't make them do anything truly villainous. They were mostly just rowdy fans of Marnie. They were easily the worst group ever that I am aware of thus far. There really isn't much to be said. I would say that this is definitely a step in the wrong direction for villainous teams. I didn't care too much for Piers or Marnie to be honest, but they did add to the story by being supporting characters and more characters to challenge when partaking in the championship tournament.
Team Star – Even though I have Pokémon Violet, I don't know much about them yet, as I have yet to begin the Team Star story. (I like to take my time with the game). However, based on what I read about them, they seem to be a gang of school bullies, which sucks. Sure, school bullies might be a step above rowdy fans, but it doesn't make sense why a group of school bullies would be referred to as "grunts" as if they were an organization that posed a real threat to society. Nonetheless, when I begin the Team Star story, I would update this and my opinion along with it.