The Short Version
The attribution is not supported by the evidence. Authoritative references and quotation research find no verified Freud writing or recorded remark containing “Sometimes a cigar is just a cigar,” and they classify it as apocryphal. The main support is a later unsourced secondary mention, which is too weak to prove Freud actually said it.