Aside from wildly incorrect translations, another source of amusement for translators and bilingual people at large is the idiosyncrasy of national idioms. In French, the word "idiom" is "idiotisme", which itself sounds like a funny "false friend".
One of my favourites has always been "mon chou" (my cabbage) as a term of endearment in French. True, "chou" can also refer to a pastry, and therefore something sweet and delicious, but I prefer the vegetable explanation. In a similar vein, it's tough to explain why "être dans les choux" (to be in the cabbage) means feeling distant or being in trouble. According to some , the reason is that "chou" sounds like "échouer" (to fail).
Another expression I encountered comparatively later in life was "avoir du chien" (to have some dog). Again a counterintuitive concept, it means to have style, or to be sexy. When I first heard someone use it, however, I thought it meant something like being assertive and energetic. There are different suppositions as to how dogs came to symbolize sexiness. Some report that "dog" was a quality attributed to talented actors in the theatre. Others believe that the association comes from the mischievousness and playfulness of the dog.
One intriguing idiom from Québec is "le bonhomme sept heures" (the 7 o'clock man), a frightening character parents once invoked to get their children to exhibit desired behaviour. As a young girl, I thought this "bonhomme" always had to show up at 7, but in fact the expression as a whole is a contraction of the English term "bone setter". Itinerant doctors would show up to set the broken limbs of patients in various locations. Patients' resultant screams would invariably frighten children, so parents took advantage.
A last example I like is "avoir coiffé Ste-Catherine" (to have styled the head of St. Catherine, as in put on a hat or do the hair), which means to be older than 25 and unmarried. Ste-Catherine's Day is on November 25th, and she is the patron saint of scholars and unmarried women. At one time, my sister and I used to wear our favourite hats and go out on the town to celebrate our single status each 25th of November. It's traditional to eat toffee on that day, which fits the occasion perfectly.
There are, of course, hundreds of entertaining idioms in every language. One that puzzled me in English was "happy as a clam". I didn't understand why clams were so happy. As it turns out, the expression as we know it today is incomplete: originally, it was "happy as a clam at high tide", since then the clams are hidden and tougher to harvest.
English endearments can be just as strange as their French counterparts: why would anyone be flattered by being called a pumpkin? A "sweet nothing" in itself is equally odd, when you think of it.
Meanwhile, I don't mean to "let the cat out of the bag", but the bag in question was supposed to contain a pig obtained in a medieval market place. Dealers would substitute a cat for the pig on display and the shady switcheroo would only be discovered on arrival.
All in all, idioms enrich language even as they often stump the efforts of translators. They certainly lead to entertaining discussions, in any language of choice.