Star Trek: TNG had an episode where Barkley gained super intelligence and started “helping” even when it wasn’t welcome, to the point where he became so powerful that he appeared to be a threat. Too bad the episode didn’t really play the scenario out and deus ex machina’d back to status quo by the end.