Supernatural had a stellar cast of characters who made lasting impressions on audiences, but one of the most intriguing was the insightful Crowley.