I dunno...I love that film, and I look back on it as inspiring. You know, the bit where he dresses in a tutu? I know it's negative, kinda, but it comes across as positive to me. Comedy always exaggerates stereotypes but it doesn't mean it's saying something is bad - it's like reverse psychology?
It at least brought transgenderism into the media. Aged 12, I would never even have known about transgender people had I not seen that movie! It just wasn't talked about at home or in school.
It's almost like the psychological role of comedy in society is to bring shadows into light.
It shows you, in a funny way, what you're NOT supposed to do. (Eg. you're NOT supposed to find trans repulsive).
In turn, this makes the audience laugh and in humour, helps them to slowly release tension and realise the right way to act.
I do this in parenting all the time.
Instead of shouting at my daughter 'DON'T do that!'
I give her a caricature of what she is doing. So if she is shouting too loudly, I will shout even louder, pout, act like her but worse.
This makes her really laugh, and immediately helps her to see what she's doing wrong, but without upsetting her.
In all honesty, the Ace Ventura films are my favourite films of all time. I constantly look back on them as inspiration for what I do today - which is stand up for animal rights, explore gender boundaries and challenge norms, and am sexually liberated in my expression. I am not afraid to be funny, pull funny faces, joke about sex, have good sex, dress as a man or a woman or inbetween. That's the beautiful legacy of those films for me.
So I'm sorry if there were negative affects for you.
I really think that upbringing might make a difference - I don't know what yours was like, obviously, but I was brought up in a liberal environment - not racist, homophobic, or transphobic, agnostic (bordering on atheist but not quite!) etc. So that set the scene for me being more accepting of trans, gay and bisexuality, occult beliefs when I came across them.
I was brought up to be alternative. To challenge the norms. I had to carry a violin to school and get accused of it being a machine gun. I was very artistically sensitive - I thought I was being bullied but now, when I look back, I realise I never understood not to take classmates seriously when they are joking. Especially male-brained humour. I have had to study Asperger's syndrome, consider whether I suffer from that and really change my perception of humour. And this really helped when I became an over-serious, ocd parent suffering from postnatal depression.