My main issue with Anise was that in "Upgrades" she screws SG-1 over, and how anyone was supposed to entirely trust her after that, much less want to have sexytimes with her, was beyond me.
Uneasy ally with some potential for redemption I maybe could have bought, but she didn't appear enough times for that to work.
I'm not familiar enough with the actor's work to say how much of the blame may lie with her performance versus other factors.
Jack never really trusted her. As for sexytimes I mean it was Vanessa Angel. She was sexy. Because the show never over played it Stargate when you look at it had a super sexy cast. Judge and Shanks were total hunks. Carter,Fraser and Anderson had more relatable beauty. I always liked how despite this the show didn't play it up which made the military environment feel more realistic and professional.
Jason