She didn't exactly take over the show, but Anya on BUFFY is another example of a one-shot guest character who ended up playing a much bigger part on the show than was originally intended.
Heck, Anya is more of a plot device than a fully-realized character in her first appearance, but the writers seemed to see some humorous potential in the character and started bringing her back . . . .