Personally I do not see any "greater scheme of things". The sex fantasies are the great scheme and the companions were designed for that, including the elven supremacy. Honestly, the cast of BG3 reminds me more of a visual novel dating game cast than companions for a RPG. And the only character in BG3 that might make any "Top X RPG character" lists is Raphael, but none of the companions.
Its no coincidence that all discussions about the BG3 characters are about sex and that NPCs got upgraded to companions because of thirsting. Larian planned to make sex a central attribute for their companions to get away with otherwise mediocre personalities and stories.
So don't blame the fans for thirsting, they are just doing what Larian designed the companions for.