Will Allah grant the asker's desire in Paradise, as a reward for his patience in enduring this worldly tribulation, to be a woman so that he may enjoy the female body himself, or to enter the body of a houri and engage in sexual relations with another houri?

This situation is strange, and Satan may have an entry point into it. You must seek refuge with Allah from Satan and not indulge in these thoughts. It is recommended to associate with good people, fill your free time with beneficial activities, fast frequently until marriage becomes possible, and pray that Allah grants you a righteous wife. Marriage is a means to richness and chastity. Allah, the Almighty, says: "If they should be poor, Allah will enrich them from His bounty." Paradise is the abode of the pure, and there is no impurity in it. The permissibility of wine or silk in it should not be analogized to everything forbidden in this world. Direct your efforts towards attaining faith, and ask Allah for His honorable abode.