You know, maybe I was too hard on Berman. Perhaps the lack of LBGTQI+ characters was truly due to creative difficulties. Maybe he really thought that the introduction of one of them should have been organic into the fabric of the series and not gratuitous, otherwise it would have been a disservice to the entire non-heteronormative community. But evidently the solution was too complex and has understandably eluded him all these years. The introduction of one of these characters was, from a narrative point of view, a titanic undertaking not within everyone's reach.
To put things in perspective, we can see Discovery managed to untie this inextricable Gordian knot, this dead-end labyrinth, the elusive white whale. I don't know if a single post is enough to illustrate the incredible complexity, story-wise, of their solution, but anyway, here it is:

Wow. More than story-telling, here we are talking about four-dimensional chess! I'm not even sure that viewers truly understood the intricacies of what they witnessed.
No one is surprised that the solution to this impossible conundrum eluded Berman & co for almost 20 years and 624 episodes! Few human minds could have come up with something like this!
P.S. Yes, I'M JOKING!
P.P.S Yes I know, it was a different time, Star Trek was a family show etc etc. The fact remains that EIGHT days after the end of Enterprise, Doctor Who (another family show) introduced this character:

without the need for complex narrative devices to explain his "non-straightness".