Actually, Picard was always very good at following it. Sisko too. Now Janeway and Kirk, not so much, especially Kirk. I mean, how many civilizations did he interrupt by shagging all their women? ;)

Yes, I imagine so. The show shows him with both types of women - top Buffy and bottom Harmony.