Just as well-known as Agatha Christie and Conan Doyle
OK, that's a bit of a stretch Aoi, considering I actually thought it was a fake in-universe author until I googled them and found out they were real.
I thought that part was pretty accurate
Dead on with this take though.
Male lead low self-esteem is a painfully overused trope in light novels, but I feel that with Holmes it's presented a lot more naturally and believably than in most cases. We know he's extremely talented, the rest of the cast know he's extremely talented and he also knows he's extremely talented, but it's not in any of the areas he really wants to have talents, so he can't help but look down on himself all the same.