Without a Clue, starring Michael Caine and Ben Kingsley, was a very funny Sherlock Holmes comedy.
.....................................................
And let’s not forget Gene Wilder and Marty Feldman in ‘Sherlock Holmes Smarter Brother’.
https://www.youtube.com/watch?v=m7gL-uafauk
There actually was a Sherlock Holmes Smarter Brother in the novels, Mycroft Holmes. He wasn't a detective but was good at solving problems................
https://en.wikipedia.org/wiki/Mycroft_Holmes