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, he 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.
In the show Justice League Unlimited Puppeteer made a cameo in the episode "The Great Brain Robbery" as part of the Legion of Doom.
In the show Teen Titans there is a villain called the Puppet King who is similar to Puppeteer. However instead of being human he is actually a magical puppet. In the episode "Switched" he tricks the titans into letting him into the tower using mail. He manages to gain control of Robin, Cyborg, and Beast Boy however Starfire and Raven escape and later use a magic potion to free the others and the Puppet King is defeated. He later makes cameos in later episodes.