Just some Startrek Notes on Sex and Romance:
Picard always seemed lawful good to me. He followed all the Federation laws, and unlike Kirk, he always tried to follow the Prime Directive. His relationships do also show this - there were approximately four or five (counting the movies) romantic partnerships in it:
He was attracted by Dr. Beverly Crusher, but he never got into it, because she was first married with his friend, and later his personal code of honor seemed, most the time, forbid a direct relationship with her - at least he never really tried (except maybe in the future timeline of the show)
He had approximately three sex partners in the show:
One he met when he was captured by some alien probe of a dead civilization that let him live a whole life on the now destroyed planet. He married (I believe he was already married to her) her and even became father, at least he always kept to this family.
Then there was Vash, our roguish archeologist. This relationship was very similar to the one of the BoEF - the first time they met was on Rysa, and they did ended their relationship when they left the planet. When he met her again, he seemed a bit embarrased about this relationship (he met Dr.Crusher on a regular basis then - not actually a date, maybe, but a very subtle try to come nearer to her, I guess) to Vash, indicating it didn`t fit in his usual behaviour "pattern" (and indicating the BoEF definition does not fit for LG). Anyway, he still proved he was feeling responsible for her...
The third was a female Science Officer (I forgot her name) aboard the station. The relationship didn`t last longer than a single episode - they split up when he decided he could not combine the relationship with his command of the ship and beeing her commanding officer. (Which probably only proves his lawful attitude, nothing regarding to the BoEF philosophy).
In Startrek 9, he had the last relationship. Not much to tell about - he left her on her planet, unwilling to give up his current life. (Not surprisingly, and probably also a lawful act - not chaning anything)
Oh, and there was Lwaxana Troi, but he was not interested in her, she was interested in him
Sisko was also quite lawful, I think, and I currently tend to consider him more neutral then Picard - he did make some very harsh decision Picard would probably never approve. (Like the assassination of the Romulan Ambassador, or some actions to capture his former Security Officer that became member of the Maquis). He was very lawful in his relationships - he only had three, if I remember correctly. His wife (that died at the Battle of Wolf 359), a short contact with Fenna (a astral projection of a married, but unhappy woman, not a "real" person in a strict sense), and Cassidy Yates, the freigther captain he is introduced to by his son. (He also met again his wife in the parallel dimension.)
The relationship with Fenna might fit into the BoEF description, but seems more chaotic (well, like most: "We have a story here that does not 100% fit the character, but want to tell it anyway because it is fun"-Stories in TV).
Mustrum Ridcully