^ Well, OK - I'll give you Intendent Kira. Although I wouldn't say she was so much gay or bi as she was predatory. The woman had NO discretion. I honestly don't think the intention was to show an evil lesbian. I think it was to show someone who was just...debauched - like Rome just before the fall.
Doesn't change the fact that one of the only times that we see lesbian action (sans alien influence) in Star Trek is when it's in the "dark", "forbidden" mirror universe.