I don’t think so. Hugh Grant was the lead in a gay romance and became a heartthrob leading man, Tom Hanks won an Oscar for Philadelphia and remains an “American National Treasure”.
I don’t think there is. I think Hollywood is very risk averse, they have said for years global audiences don’t want films with black leads, not that they are against them, and then Black Panther made a billion dollars including being a massive hit in places like Asia.
In the 60s they went to great lengths to pretend that The Beatles didn’t have girlfriends (and John was even married) so they seemed attainable for the teen girl audience. That’s mostly passed now but they still do it with K-Pop acts in Korea.
As with professional sports there is a statistical anomaly with the absence of gay people in leading positions. We know they exist, in England the head of the football players union told gay rugby player Gareth Thomas in a documentary he has had confidential discussions with several Premier League players who are afraid to come out in a macho environment. (Thomas is extremely rare in being an out gay man in a team pro sport, tou can count them on one hand almost, and he lived a lie for many years to the extent he got married to a girl he knew growing up).
In film there should be some leading actors who are gay you’d think (we know the South Park jokes about Tom Cruise and his closet) but I suspect they are afraid that conservative approach by execs could harm their careers. We saw that with Rock Hudson, admittedly in a less open era than now but he put up a facade for fear of losing those parts. A couple of years after Hudson’s death Ian McKellen was confident enough to come out publicly but his career was very different, as a stage actor then playing classical roles. (Notably for both Hudson and McKellen their fellow actors knew they were gay for years but they kept it out of the public domain so I don’t think at all the issue is internally in the acting profession).