Very nicely written longread on the trope, its implications, and reality. I freely admit to being a sucker for the type, and had married one some time ago...

For purposes of discussion, my all-time favourite exemplar was played by Donal Logue's real sister as his character's sister in Terriers: Brainy Manic Pixie Dream Girl...