You'll also have to add all the various interpretations of Carmen on this list. One of the most spectacular is the Senegalese version of that tale: Karmen Gei. And.... French cinema has a lot of these women, definitely Jules and Jim, and even Murmur of the Heart. This is a nice topic to think about.
Another list I wanted to make... But then there's always a great Kenji-list. Some suggestions: PANDORA AND THE FLYING DUTCHMAN (Albert Lewin, 1951), DE MAN DIE ZIJN HAAR KORT LIET KNIPPEN (André Delvaux, 1965), HUNGER (Henning Carlsen, 1966), ACCIDENT (Joseph Losey, 1967), EXOTICA (Atom Egoyan, 1994), TWO LOVERS (James Gray, 2008) and LE NOTTI BIANCHE (Visconti 1957).
Manoel de Oliveira's new one: Eccentricities of a Blonde-Haired Girl is also one about an unattainable woman.
You've hit on one of my favorite themes here, though I'm not sure how some of the films fit in. I guess it won't surprise you that my favorite opera is La Boheme: addio senza rancor
No, sorry for pestering. But yeah, when I see her in those movies, I definitely think "unattainable," and not just in the sense that she's gone...
Wait, you think Rita Hayworth should have had her hair cut for "Gilda" too? I dunno. I love seeing that one shot of her, shoulders exposed, whipping that beautiful hair back.
And for the LOLs, "The Lady in Red" with Gene Wilder. Complete with great Stevie Wonder music!
I thought he cut the locks for "Lady from Shanghai?" Also, might you consider "That Obscure Object of Desire" or "Annie Hall?"
Love this list. I never thought about it, but it's a common recurring cinematic theme. I also love the lack of post-2000's pseudo-indie films like 500 Days of Summer and Garden State which seems to thrive on the theme of males being unable to handle their lives instead of the grand scale of things in films like Sansho the Bailiff, Brazil and especially Vertigo.
Isn't every almost Scorsese film in part about the mystery that is woman? Though, this list is refreshingly devoid of post-2000 hipster indie chicks. You know who you are Kate Winslet, Zooey Deschanel, Natalie Portman! Throw me some Gilda!