The actor, 62, on losing her brother, awful things directors have said, and having enough of Sex and the City