Yeah, so my married sim with the "Soulmate" aspiration (and maxed out green/pink bars) developed the "want" to flirt with a paparazzi who keeps showing up to pester his spouse and uh...NO! THAT IS NOT ALLOWED. We do ONE thing with the paparazzi, we feed them to our son (who is a vampire). We do not invite them in, we do not dance with them, and above all, WE DO NOT CHEAT WITH THEM, for pity's sake....
I could not figure out how to get rid of that want without encouraging this homewrecking behavior so I switched off wants/fears to purge it, then switched them back on. I generally try to merely guide my sims and not force them to do everything...but yuck...this is a household, not a pig-sty, for pity's sake!