In Harry Potter, Dumbledore is closely related to Harry. Dumbledore is an elder, so he is directly called by his first names, just as Ron and Hermione are also called by their first names. Others are usually called "Mr. Potter" and "Mr. Weasley".
In Sherlock Holmes, Watson's name is Sherlock Holmes, which is a respect for him.