I’ll admit, I’ve never been a fan of murder mysteries. Patience is not one of my virtues; if I can’t work something out in 30 seconds, I’m liable to give up, and whodunnits tend to need a bit longer than that.

It’s no secret that Arthur Conan Doyle’s most famous creation lays claim to more appearances on screen than any other fictional character. Over the past several decades, we’ve seen Sherlock as a pugilist action-hero, a modern-day sleuth, and in a painfully unfunny slapstick guise.

Sherlock’s back in the here and now, and not before time. Twelve months ago, Benedict Cumberbatch’s Holmes laid down his mobile phone to return to Edwardian London for a plate-spinning deer-stalking mind-warping one-off. The Abominable Bride, though good in parts, caused a mass outbreak of head-scratching. Had Team Gatiss/Moffat fallen a little too in love with metatextual rebooting and gone and got lost in their own hall of mirrors?

Since Benedict Cumberbatch is now one of the world's most in-demand actors, and his sidekick Martin Freeman isn't doing too badly either, getting them on a set together is like trying to get Simon & Garfunkel to do a reunion. Hence Sherlock fans now have just this one-off New Year special to slake their Cumberlust.

In 1998, Ian McKellen starred in Bill Condon's Gods and Monsters, an account of the final days of the ailing and tormented film director James Whale. Echoes of it are discernable here, where Condon has recruited an older McKellen for a carefully-crafted depiction of the imaginary dotage of Arthur Conan Doyle's great fictional detective. Aged 93, the doddering sleuth struggles to reassemble the jumbled jigsaw of his memories and hence solve his final case, which turns out to be himself.

Condon has based his film on Mitch Cullin's novel A Slight Trick of the Mind, and the narrative whisks us back to 1947 and a melancholy rural England still trying to drag itself from the wreckage of World War Two. We first meet Holmes in a railway carriage as its steam locomotive chugs through garden-of-England Sussex countryside, the view occasionally scarred by the rusting wing of a Luftwaffe aircraft sticking out of a field. There's no sense of an enemy triumphantly vanquished, more of regret for something lost forever. Holmes's gruff assertion to a schoolboy passenger that what he thinks is a bee is in fact a wasp not only establishes him as a bit of an old grouch, but also previews a recurring apiaristic theme.

Having long ago called time on his career as a "consulting detective", Holmes has retreated to his rambling old house a stone's throw from the sea, where he tends his beehives and racks his brains for recollections of his glory days. His only companions are his tetchy, unhappy housekeeper Mrs Munro (Laura Linney) and her son Roger (Milo Parker, pictured above with McKellen), the latter a fan of the Holmes mythology who also bonds with the old man through a shared fascination with bees. His once scalpel-sharp mind is growing foggy, and Holmes's friendly local doctor (Roger Allam) asks him to make a dot in his diary every time he can't remember a name. As the story progresses, the dots gather like a black snowstorm. McKellen, equally persuasive as the dapper, pleased-with-himself Holmes in his prime and the fearful old man he has become, can expect some gongs heading his way.

Condon's dominant theme is memory, not just the way Holmes's faulty one chops up the past into fragments and non-sequiturs, but the way memories can be distorted or manufactured. On a trip to Japan, to track down the supposedly memory-enhancing prickly ash tree (prompting a disturbing visit to the ruins of Hiroshima), Holmes has to explain to a local fan that he never wore a deerstalker or smoked a pipe, but these were just inventions of a book illustrator. Holmes reflects sadly on his brother Mycroft, Mrs Hudson and Dr Watson, all long gone now, but he still hasn't quite forgiven the latter for his penny-dreadfulesque fictionalisations of Holmes's great cases.

It's the final one, The Case of the Grey Glove, that has been preying on Holmes's mind. Condon has some fun with a scene where Holmes goes to the cinema to be appalled by a melodramatic film treatment, The Lady in Grey, with Frances Barber in the title role. Meanwhile, Holmes has been laboriously trying to write his own definitive version of events, in which he investigated the failing marriage of Thomas and Ann Kelmot (Patrick Kennedy and Hattie Morahan, pictured above with McKellen). Suffice to say that we learn why the case prompted Holmes to call time on his detective work, and its tragic overtones shine a piercing and poignant light into the soul of the erstwhile doyen of Baker Street. When Holmes comments that "I've been alone all my life, with the compensations of the intellect," it makes you ponder an interior Holmes that Dr Watson cheerfully ignored. And when that intellect begins to fail, what is left?

Though Condon is chiefly concerned with a crumbling, misfiring Holmes, the denouement permits a belated flash of the old deductive powers, and it helps Holmes to make the human connection that has eluded him for so long. Despite its stately pace and determination not to do anything rash – it's the antithesis of the hyperactive clever-dickery of the Cumberbatch Holmes – Mr Holmes is a quiet triumph whose ripples will keep washing over you long after you've left the cinema.

Overleaf: watch the trailer for Mr Holmes

“Something strident and stirring – play to us now, please!” demands Martin Clunes’ Sir Arthur Conan Doyle to the piano-playing vicar’s wife, on apprehending that their conversation is being eavesdropped on. Sherlock Holmes himself could hardly have responded more adeptly to frustrate the eavesdropper, and as Conan Doyle’s pursuit of the intruder leads him to a sinister, candle-lit shrine containing the vicar’s daughter’s long-lost favourite doll, it’s clear that ITV has a new thriller both strident and stirring on its hands.

As Benedict Cumberbatch's Sherlock reached the end of its latest brief span, Timeshift [****] surveyed the history of dramatic interpretations of Baker Street's finest with a wry eye, in a narrative sprinkled with nutritious facts and anecdotes.

In our big-bang globalised environment, Sherlock Holmes is now more like a Marvel Comics superhero than a mere "consulting detective". We take it for granted that his deductive powers can peel open the physical and psychological secrets of a complete stranger within milliseconds, while the scope of his ambitions has advanced from solving quaint Edwardian mysteries to unpicking global conspiracies and phantasmagorical terror threats.

Last year at the National Theatre, Jonny Lee Miller appeared in Frankenstein with Benedict Cumberbatch ("two excellent performances", according to theartsdesk's Sam Marlowe). Maybe something rubbed off, because now here's Miller following in Cumberbatch's footsteps as another 21st-century Sherlock Holmes, in this new series from CBS in the States.

We in the UK have much enjoyed our contemporary Sherlock Holmes recently, courtesy of Cumberbatch et al. It’s amazing to think that, at the height of the Cold War, Soviet television was bashing out TV versions of the Holmes stories. And they were water-cooler discussion productions (despite obvious absence in those days of water-coolers). Director Igor Maslennikov made no fewer than nine Conan Doyle-themed works in the late 1970s and early 1980s. The first of these to reach further shores in DVD format is this 1981 account of The Hound of the Baskervilles.