It was a fun part of the game. The funny thing is with the new moody Cloud that appeared in AC and the later games you just can't see him doing it now.

Also there was nothing mature about him in drag, it happens in children's pantomime all the time. The fact he then enters a whore house on the other hand...