For more classical ones, apart from the BBC stuff that everyone recommends, there's a very good 1979 film called Murder By Decree starring Christopher Plummer as Holmes.
I have to respectfully disagree with you about this one here. I recently watched Murder by Decree
for the 1st time. In the 1st place, it's boring as hell. In the 2nd place, it has fuck all to do with the characters that Arthur Conan Doyle created. It's not really a Sherlock Holmes story. It's just a movie that used Holmes as a vehicle to examine recent historical theories about Jack the Ripper. And then there's Donald Sutherland playing a psychic for some reason. For Holmes to pay any legitimate attention to a psychic at all is completely antithetical to the character. Honestly, as far as authentic Holmes stories go, you'd even be better off with Young Sherlock Holmes.
A lot of great options here. The most accurate thing you will find is the Jeremy Brett television series. They follow the stories very closely, and feature good production values. Many consider Brett the definitive Holmes. I also recommend The Private Life of Sherlock Holmes (a comedy).
I don't really think The Private Life of Sherlock Holmes
is a comedy. It's kinda "funny" when Holmes tries to get out of being propositioned by a Russian ballerina by claiming that he & Watson are gay. But other than that, it's a pretty straight story (albeit absent the usual Holmes forensics) about international espionage & the Loch Ness Monster.
Personally, I would best recommend the BBC series Sherlock.
Despite its contemporary setting, it absolutely nails the characters and some of the dialogue is lifted straight from the original stories.