This made me chuckle
I moved from Rockford, IL to Hollywood Ca when I was 14. I think I was about 18 when a girl I was dating asked me to go see it. I'd heard about it, but had no real idea what it was about.
I was a bit shocked by it. I saw trannies everyday living there, but I was amazed by all the people who were there dressed in character and playing out the parts while the movie was showing, and all the throwing of rice and water and what not by the rest of the audience.
Yes, you should see it, and I'll tell you why. People actually lived for that movie. It meant something big to them. In Los Angeles back then everyone there belonged to a "clique", and Rocky Horror created one, which is notable.
I don't think that was intentional. I don't see how it could have been. It was intended to be campy and they pulled it off wonderfully well. It's pretty hard not to jump up and "Do the Time Warp" by the time it's wrapping up. You have to work at keeping yourself stuck in the mud to not get up and dance with everyone by the end of that movie, and that alone makes it worthwhile.
But it's notable because of the subject it exposed. It opened a window into a lifestyle that most people didn't have a clue about. It depicted being gay or bi as harmless fun and made them less scary for straight people. It inspired a lot of people to come out of the closet, and others who were never in one to get up and dance with them just for the fun of it. The reach of that effect was by far greater than the movie itself.
I saw it again in my late 20s and had a lot of fun. By then I wasn't feeling the pressure anymore to join a clique or explore my sexuality. I was fine being straight and didn't care if someone was gay or bi as long as they weren't hounding me incessantly, which I'd found didn't happen very often
So, yeah, I think everyone should "Do the Time Warp" at least once, even if you are 80 years old