Catherine Tate, Rebecca Front and Katy Brand are among the stars exposing the obsessions and psychoses of history's most famous women.