There is nothing erotic or titillating about The Institute of Sexology, an exhibition the Wellcome Collection plans to keep open for a year. Those expecting a display of fertility symbols, fetish objects, kinky clothing or sex aids down the ages will be deeply disappointed. Just about enough objects and images are included to keep you interested, but the bulk of the show is not dedicated to sexual practices but to the 19th- and 20th-century doctors, anthropologists and psychologists who spent their lives studying sexual behaviour. 

There’s a giant spider in the Scottish National Gallery of Modern Art’s new exhibition of Louise Bourgeois. Her trademark spider and the fact that she lived to 98 – working into her final days – are probably two of the best-known things about her. The story spun by the spider and the other exhibits, in an exhibition entitled A Woman Without Secrets, makes a fascinating walk through the final years and lifelong obsessions of the French-born artist who did not come to real prominence until her early 70s in her adopted USA.

I am increasingly finding it almost impossible to express just how bored I am by Miley Cyrus. I mean, seriously, are we really in such a fix that this guff is a serious talking point? A second-generation celebrity and former child star seems to be going off the rails a bit? OH REALLY, GOSH, THIS HAS NEVER HAPPENED BEFORE, PLEASE TELL ME MORE. A young female celebrity is flashing her parts? SWEET BABY JESUS ON A BORIS BIKE THIS IS AMAZING. A white pop star is crassly adopting the tropes of black culture? WOW NO WAY, YOU'RE LITERALLY SHITTING ME.

In playwriting, there’s near-perfection, perfection and oh-my-God-how-I-wish-I’d-written-that. Terry Johnson’s Hysteria, which was first staged at the Royal Court 20 years ago, is definitely in the OMG category. Subtitled “Fragments of an Analysis of an Obsessional Neurosis”, it is now a contemporary classic, and deservedly so. Both a demented farce and a serious study of psychoanalytical theory, both surrealistic and feminist, both arty and troubling, it is also a fantastically brilliant entertainment.

Hysteria is back. Terry Johnson’s comedy was written for the Royal Court in 1993, and for its 20th anniversary it is being revived at Hampstead Theatre. It is a homecoming in a sense: the play is set in the Hampstead home of Sigmund Freud, where he receives unexpected visits from Salvador Dalí and a young woman who cannot keep her clothes on. Freud will be played by Antony Sher.

Early on in Dangerous Edge: A Life of Graham Greene, John le Carré remembers Greene telling him that childhood provides “the bank balance of the writer”. Greene remained in credit on that inspiration front throughout his life, even while he struggled financially in his early writing days with a young family; later in life, too, he lost everything to a swindling financial adviser – the move to France was to avoid the Revenue.

Stephen Soderbergh would have us believe that this might be his last movie, which is difficult to believe. But if so, he's bowing out with one his sharpest, most devious and most watchable pictures, in which a shrewdly-chosen cast does full justice to a screenplay over which Scott Z Burns has pored painstakingly for more than a decade.

What would Sigmund Freud say to newcomers infiltrating his priceless collection of Greek, Chinese and Egyptian antiquities? His study on the ground floor of 20 Maresfield Gardens in Hampstead, where Freud and his family lived after fleeing the Nazis in 1938 (he loved the house, saying it was “incomparably better” than his flat in Vienna, but only lived in it for a year before he died in 1939) has always been filled with his Egyptian gods and goddesses, bodhisattvas and buddhas, Eros figures, mummy masks and Greek vases.

Louise Bourgeois tirelessly, obsessively documented her 32 years of psychoanalysis. Before the discovery of her secret cache of personal musings – sheaves of hand-written notes outlining dreams and psychic burdens, doodles and self-excoriating lists – nobody had any idea that the celebrated French-American artist, who’s often been associated with Surrealism, had undergone such protracted, intensive therapy, even though it’s really all there in her work in terms of its feverish Freudian symbolism.

Those who are “Jung and easily Freudened” (to misquote Joyce) need have nothing to fear from David Cronenberg’s A Dangerous Method.