I don’t think the question is about which other books generate big movies. The HP books themselves were huge cultural moments and were sold out within hours in many places.

I am not aware of any Sherlock Holmes work being re-edited in the past couple of decades, let alone generating such expectation as the HP book series. (The lack of expectation is relatively normal, the SH works were written and published long ago, the author is dead, there is no new book coming out. They also do not appeal to people of all ages and all genders the way HP does).