As the Dutch queen reopens the Netherlands’ Van Gogh Village museum, Lucy Shrimpton gets on the lesser-known art trail and discovers there was plenty of drama before the ear and the pistol