Sex and the Single Alien (1993)

Harry Smith is your typical sexually-unfulfilled husband whose wife Olivia is more interested in UFOs than in him. With the help of his friend Sam, Harry makes Olivia believe that he has been abducted by aliens, when really he has an affair with the new dancer at the strip club which he and his wife own. But the tables are turned when Harry really is abducted by aliens, and they give him the remarkable ability to bring a woman to orgasm simply by looking at her.