This resonates with me to an uncomfortable degree--I always joke that my school friends were Barbies, but that's because they fit the Swedish beauty ideal, and it definitely showed, so I always considered myself ~The DUFF~
But I have more to say on this "Is it hot to envy another woman’s looks?" makes me wonder how much of this is about misunderstanding dynamics between women/girls because within fandom spaces, yes. That type of fixation is considered romantic, ex Yellowjackets' Shauna & Jackie; fandom has reframed what we see of Shauna as a lesbian obsession. I remember seeing that for MSCL's Angela and Rayanne as well. Or maybe it's not misunderstanding as much as wishful thinking? I don't know. It seems to always come from observers though.
ETA: and dur, of course Archie's Betty and Veronica which did get portrayed as a hot relationship ultimately in Riverdale.