What 'The Wizard of Oz' movie forgot to mention is that in the Oz books, Glinda has the 'Book of All Knowledge' meaning that she knows EVERYTHING that is happening and WILL happen. She also certainly has more power than Princess Ozma (the royal ruler of Oz).
In all, she's taken on more of an Ancient God role similar to the Greek pantheon in which she has enormous power but uses it to meddle in the lives of mortals, munchkins, witches, and all.
Scarlett O'Hara doesn't surprise me. I always thought she was a spoiled brat. Of course, if her character were male and did that stuff, nobody would blink an eye.
Sherlock Holmes doesn't surprise me, either. He screamed 'autistic' when I first read about him in junior high. And his acting does make sense - I knew plenty of actors back in high school and college who were autistic. They felt more comfortable taking on a role than 'being themselves'.