Oh look. It's this one again. Honestly that list is like the worst fanfic from the people who would be banned by the horney hammer. Stop being suckered in and let the stories an characters tell their own story. You know why no one goes on about this shit in Star Trek? Because it's not supposed to matter. Aspire to this.
Many of those who worked on trek from the very beginning would very much disagree with you.
This video is a great essay that backs up the above statement in a few different ways: https://youtu.be/j5_g1DY1FLg
I encourage you to sift, if not watch through it. It’s not exactly short and succinct but it takes you through a journey of trek history in the context of LGBTQ, and as it goes on draws more and more parallels to other trek projects beyond DS9 and JulianxBashir, in addition to general film history on the subject of both LGBT and civil rights.