“Fear of emotional contact with men out of fear of being a sexual suspect makes boys, ironically, even more powerless before girls. Homophobia is like telling the United States it will be a sissy nation if it doesn’t get all its oil from OPEC.”

This is not a statement that has been found in any translation of any of Freud's known works. It is a paraphrase of a statement from the essay "Guns, Murders, and the Constitution" (February 1990) http://www.guncite.com/journals/gun_control_katesreal.html by Don B. Kates, Jr. where Kates summarizes his views of passages in Dreams in Folklore (1958) by Freud and David E. Oppenheim, while disputing statements by Emmanuel Tanay in "Neurotic Attachment to Guns" in a 1976 edition of The Fifty Minute Hour: A Collection of True Psychoanalytic Tales (1955) by Robert Mitchell Lindner:
:: Dr. Tanay is perhaps unaware of — in any event, he does not cite — other passages more relevant to his argument. In these other passages Freud associates retarded sexual and emotional development not with gun ownership, but with fear and loathing of weapons. The probative importance that ought to be attached to the views of Freud is, of course, a matter of opinion. The point here is only that those views provide no support for the penis theory of gun ownership.
: After reading of this essay and its citations, this paraphrase of an opinion about Freud's ideas has been attributed to Freud himself, and specifically to his 10th Lecture "Symbolism in Dreams" in General Introduction to Psychoanalysis on some internet forum pages: alt.quotations http://groups.google.com/group/alt.quotations/msg/5fc8dd0f7d56981e, uk.politics.guns http://groups.google.com/group/uk.politics.guns/msg/4ad060e213bc5b6b, talk.politics.guns http://groups.google.com/group/talk.politics.guns/msg/7fbce4b3fa5324a7, can.talk.guns http://groups.google.com/group/can.talk.guns/msg/a57bc07124e64fba , etc.
: One of the statements by Freud which Kates summarized from in Dreams in Folklore (1958), p. 33, reads: "The representation of the penis as a weapon, cutting knife, dagger etc., is familiar to us from the anxiety dreams of abstinent women in particular and also lies at the root of numerous phobias in neurotic people."
Misattributed

This is not a statement that has been found in any translation of any of Freud's known works. It is a paraphrase of a statement from the essay "Guns, Murders, and the Constitution" (February 1990) http://www.guncite.com/journals/gun_control_katesreal.html by Don B. Kates, Jr. where Kates summarizes his views of passages in Dreams in Folklore (1958) by Freud and David E. Oppenheim, while disputing statements by Emmanuel Tanay in "Neurotic Attachment to Guns" in a 1976 edition of The Fifty Minute Hour: A Collection of True Psychoanalytic Tales (1955) by Robert Mitchell Lindner:
Dr. Tanay is perhaps unaware of — in any event, he does not cite — other passages more relevant to his argument. In these other passages Freud associates retarded sexual and emotional development not with gun ownership, but with fear and loathing of weapons. The probative importance that ought to be attached to the views of Freud is, of course, a matter of opinion. The point here is only that those views provide no support for the penis theory of gun ownership.
After reading of this essay and its citations, this paraphrase of an opinion about Freud's ideas has been attributed to Freud himself, and specifically to his 10th Lecture "Symbolism in Dreams" in General Introduction to Psychoanalysis on some internet forum pages: alt.quotations http://groups.google.com/group/alt.quotations/msg/5fc8dd0f7d56981e, uk.politics.guns http://groups.google.com/group/uk.politics.guns/msg/4ad060e213bc5b6b, talk.politics.guns http://groups.google.com/group/talk.politics.guns/msg/7fbce4b3fa5324a7, can.talk.guns http://groups.google.com/group/can.talk.guns/msg/a57bc07124e64fba , etc.
One of the statements by Freud which Kates summarized from in Dreams in Folklore (1958), p. 33, reads: "The representation of the penis as a weapon, cutting knife, dagger etc., is familiar to us from the anxiety dreams of abstinent women in particular and also lies at the root of numerous phobias in neurotic people."
Misattributed

Fear: The History of a Political Idea

"The House Opposite," http://books.google.com/books?id=UZ8uAAAAYAAJ&q=%22Boys+will+be+boys+And+even+that%22+%22wouldn't+matter+if+we+could+only+prevent+girls+from+being+girls%22&pg=PA137#v=onepage Westminster Gazette (1893)

As quoted in "The Trump Era Is Al Franken’s Time to Shine" by Graham Vyse, in New Republic (2 February 2017) https://newrepublic.com/article/140342/trump-era-al-frankens-time-shine

The Mentors on Hot seat, 1992.

Strukturen des Bösen III LXXVII (fifth edition 1986)

Source: Straight with a Twist (2000), p. 27.