I am male and expressed an opinion that prostitution should be legal. But I have no desire to ever actually use such a service personally.
My opinion is based largely on the fact that there are plenty of women who want to do this, or particularly enjoy it, as well as the unfortunate cases of people who feel they have no other choice. In either of those cases, punishing the people who are in this industry is wrong.