That's what I was thinking when I saw this question. There are no other characters that have a particular "entrance" on this kind of level or made such an effective impact on the audience and characters alike other than Castiel. And I like your equivalent comparison to Darth Vader's entrance, which I absolutely agree. That or Number Six from the BSG miniseries. ;)