A colorful metaphor, or profanity, is a use of slang language or physical expression intended to emphasize derision, curses, or other emotional outbursts. Although such usages were uncommon in the 23rd and 24th centuries, they were an essential part of 20th century conversation, seen in the novels of "giants" such as Jacqueline Susann and Harold Robbins.
In 2063, Lily Sloane used the expletive "bullshit" twice in response to Captain Jean-Luc Picard of the Enterprise-E when his crew traveled to her time to stop the Borg's attempt to prevent first contact. She first used it when Picard told her that he was here to help while she was firing at him and Data, she later used it when he denied that he had a desire for revenge against the Borg. (Star Trek: First Contact)
In 2152, when Silik desperately tried to contact his benefactor at the Helix, Jonathan Archer emerged and attacked Silik. He answered "I said you're an ugly bastard." to Silik, who had just asked his benefactor to repeat what he said before Archer arrived. (ENT: "Shockwave, Part II")
In 2153, Charles Tucker III called Kessick a "stupid son of a bitch". Later, Captain Archer cursed, "The son of a bitch lied to us!", after discovering the destroyed Xindi homeworld Kessick sent Enterprise to. (ENT: "The Xindi")
Archer warned Degra, "Listen to me, you son of a bitch!", before explaining what would happen if Earth is destroyed. (ENT: "Azati Prime")
After being called a "son of a bitch" by Jeremy Lucas, Arik Soong told him that his mother was actually a chemist. (ENT: "Cold Station 12")
In 2155, ambassadors at the meeting to form the Coalition of Planets noted that xenophobic Humans were using "language that is not programmed into the universal translator", which Nathan Samuels brushed off as emotional outbursts during a stressful time. (ENT: "Terra Prime")
In 2285, Doctor Leonard McCoy referred to Spock as "that green-blooded son of a bitch", while suffering from the transfusion of the Vulcan's katra into his own mind. (Star Trek III: The Search for Spock)
When the crew of the USS Enterprise time traveled to 1986, James T. Kirk began using "colorful metaphors" in an effort to blend in. However, he felt that Spock shouldn't attempt them, as he didn't "have the knack." (Star Trek IV: The Voyage Home)
In 2293, Montgomery Scott referred to the new Klingon Chancellor, Azetbur, as "That Klingon bitch killed her father". (Star Trek VI: The Undiscovered Country)
In 2364, Jean-Luc Picard uttered the curse, "Merde" ("Shit" in French) when the Enterprise-D was drained out of power by the Tkon Portal 63, near Delphi Ardu IV. (TNG: "The Last Outpost")
William T. Riker commented that Alidar Jarok's knowledge of Klingon curses was impressive, after Jarok had referred to Worf as a tohzah, adding that "only a Veruul would use such language in public." (TNG: "The Defector")
Klingon Governor Vagh, swore to Picard after Picard denied the charges of supplying weapons to terrorists. Picard returned the favor. (TNG: "The Mind's Eye")
After Montgomery Scott was released from the USS Jenolan's transporter in 2369, he initially argued with the USS Enterprise-D's computer while attempting to view the bridge of the USS Enterprise in the holodeck, finally (through gritted teeth and frustration brought on by intoxication) specifying the ship's registry number as "NCC-1701 – No bloody A, B, C, or D." (TNG: "Relics")
When the USS Enterprise-D was about to crash into Veridian III, Data expressed the shock and horror he felt (thanks to his newly installed emotion chip) with a suitably colorful metaphor, saying "Oh, shit." (Star Trek Generations)
The Species 8472 recreation of Boothby, stationed on Terrasphere 8, referred to the concepts making up the United Federation of Planets: "tolerance for all species, the Prime Directive" as "targ manure," during talks with Kathryn Janeway and the senior staff of USS Voyager. In response to those statements, Tuvok corrected Boothby and stated "your metaphor is colorful, but inaccurate." (VOY: "In the Flesh")
In 2258 of an alternate reality, young James T. Kirk, banished to Delta Vega for attempted "mutiny" on the orders of Spock, used the "accurate" version of this metaphor, "Bullshit", when the old Vulcan who saved him from becoming a native beast's dinner - who not only recognized him on sight but professed to be his lifelong friend - identified himself as Spock. (Star Trek)
Miles O'Brien used mild Irish expletives, usually the word "bloody." On one particular occasion, when Molly O'Brien fell into the past through a time portal on the planet Golana, he used the stronger expletive "bollocks" when some of the equipment he used in an attempt to retrive her malfunctioned. (DS9: "Emissary", "Q-Less", "Empok Nor", "Time's Orphan")