Jordan Weir first appeared as a villain to Green Lantern. His schtick was a "hyptno-ray" which allowed him to control most individuals that came under its sway.
Jordan was defeated by Green Lantern, and except for an appearance working for Doctor Destiny plaguing the Justice League, wasn't seen for several years until resurfacing as a hired gun for the villainous organization, the H.I.V.E., who hired him to eliminate the Titans. Though he was able to successfully able to control Wonder Girl, Starfire, Cyborg and Kid Flash simultaneously, the remaining Titans ( Robin, Raven and Beast Boy (then called Changeling)), were able to free their comrades and track down and imprison the Puppeteer.
He may be responsible for the deaths of the family of Adrian Chase. The methods fit some of his past crimes (an exploding marionette), but whether he was responsible has not been confirmed.
He was freed from jail by Wildebeest, along with the Disruptor, Gizmo and one of the Tridents (see Trident, it's complicated). Trident, Gizmo and Disruptor were recaptured. The fate of Weir is undetermined.
Major Story Arcs
Green Lantern: Menace of the Giant Puppet
Green Lantern is in the parade thinking about bank robberies which have been occurring recently and how the crooks all seem to have been under some sort of spell like they were puppets. He joined in the parade in the hopes the mastermind behind this would come out to attack him.
At that moment, the large puppet behind him began to attack him with a ray gun. After stopping the puppet, he finds that the person who should be controlling the puppet is unconscious and realizes some Puppet Master is behind this, but since he can't find him, he decides to hurry to Carol.
Meanwhile, the Puppet Master is frustrated with his failure to eliminate Green Lantern and makes a plan to destroy him once and for all. While Green Lantern is dancing with Carol Ferris, the Puppet Master unleashes an improved hypno-ray to try to control Green Lantern, but Green Lantern then thinks of a way to use this to his advantage. He willingly lets him capture him but as soon as he's taken to the Puppet Master's lair, he prepares to capture him. Unfortunately, the Puppet Master is wearing all yellow and so his ring is powerless on him. As the Puppet Master attempts to fire a ray-gun to kill him, Green Lantern uses his ring to grab several cords and captures the Puppet Master and sends him to the police.
Justice League of America: When Gravity Went Wild!
Monty Moran, known as the Getaway Mastermind, had devised a way for himself and his fellow prisoners: Captain Cold, the Clock King, Doctor Destiny, Professor Menace, Electric Man, and the Puppet Master. He shrinks them down in size and and villains escape on a miniature zeppelin. Upon hearing about the crooks escape, Wonder Woman, Flash and Green Lantern would try and capture them.
Jordan Weir has no innate abilities, but he has created several puppet themed devices. The hyptno-ray allows him to control others. He has also built and employed puppet sized robots which shoot very real weapons, or explode with sufficent force to destroy an apartment.
In other media
Justice League Unlimited
Puppeteer appears in Justice League Unlimited as a member of the Gorilla Grodd's Secret Society. He makes cameo appearances in "The Great Brain Robbery", in Society secret base, when Lex Luthor's mind switched with Flash's.