We tend to not use the article before proper nouns but there are exceptions. In you first example "Windsor Castle" does not take an article. In your second example, "Windsor Castle" acts as an adjective modifying "Pub". Therefore, it takes an article. With "Sistine Chapel", "Sistine" is an adjective. Therefore, it takes an article.
Student or Learner