Hmmmm Sherlock might be interesting, but honestly Doyle's Sherlock wasn't quite so dapper, not to mention not many of our current events are investigation based, so his powers might not come into play very often.
For something more fitting his personality and with a more tangible power set, I think you might want to look at two classes of characters: Helpers/Guides, like the Gray Wolf essence Eustace has, Cinderella's Fairy Godmother, or <a=https://www.pitt.edu/~dash/grimm136.html>Iron Hans from the titular tale; or trickster heroes, like Odysseus and Hermes or the Valiant Little Tailor. I could also see characters like Zorro or Hans-my-Hedgehog being good matches for him. I might have more suggestions in the morning, but hopefully these are some good ideas to toss around.
Late with Starbucks
For something more fitting his personality and with a more tangible power set, I think you might want to look at two classes of characters: Helpers/Guides, like the Gray Wolf essence Eustace has, Cinderella's Fairy Godmother, or <a=https://www.pitt.edu/~dash/grimm136.html>Iron Hans from the titular tale; or trickster heroes, like Odysseus and Hermes or the Valiant Little Tailor. I could also see characters like Zorro or Hans-my-Hedgehog being good matches for him. I might have more suggestions in the morning, but hopefully these are some good ideas to toss around.