There is a series of books (I think the author is R.L. Trow) about Inspector Lestrade, trying to show he's not as stupid as Holmes/Doyle makes him out (police are baffled!). Others have tried to construct stories based on the cases Watson only mentions in passing.
RtS