NSFW Something that appears to be impressively effective, yet is completely ineffective.
Upon losing all credibility/power, he is considered now a Nerf Dildo.