We have always been drawn to women in history who were beautiful, sensuous, and mysterious – who seduced and mesmerised