My personal ranking of Star Trek by how gay they are is as follows:

1. Lower Decks - just straightforwardly queer with its bisexual main character and many others.

2. DS9 - trans worm girl, grumpy detective with sexual tension with his fave criminal short king, evil gay tailor, gay shapeshifter commingling. I could go on.

3. TOS - Kirk/Spock. Only the most prototypical slash pairing of all time.

4. TNG - Beverly Crusher fucks a ghost (that also fucked her grandma) and thats arguably kind of gay. Also Riker falls for a trans fem alien from a fully non binary culture.

5. Voyager - Harry and Tom should kiss but they can’t because it’s Voyager and on Voyager we can’t have nice things.

6. Enterprise - All the worst gender dynamics you remember from sitcoms and romantic comedies in the early aughts but in space. Scott Bakula is also there.