Lust never makes anyone happy. Oh, it may be pleasant in the short term, but in the end it's deadly (and boring). True happiness lies in embracing the will of God. Our hearts are restless, as St. Augustine says, until they rest in Him. Pray for those inflicted with the cross of same-sex attraction that they may find the love of Christ and the peace that surpasses understanding.
If you haven't watched The Third Way, take a look.