I feel a common issue with such "dead bedroom" discussions is the seeming lack of capacity of some parties (including some prominent toplevel comments here) to understand how deep a need for sex many people have. To think sex can be replaced with "strong friendships" is laughable to anyone who actually feels a strong desire for sex. The dead bedroom situations I've seen with my friends (M->F equally as well as F->M)…
> dead bedroom situations are always the result of one party being incapable of understanding the other's desire for sex. Couldn't disagree more. Sexual attraction is not about 'understanding' how your partner feels. A man who is no longer attracted to his wife won't suddenly become attracted when he understands how she feels. Attraction is not a choice. It's not something you can talk yourself or someone else into.
This seems based in some fantasy land, though. I'd be absolutely stunned if you didn't have at least a few unattractive friends who do very well in dating/relationships/finding sex partners, because they are funny, or charismatic, etc (speaking about male friends here generally but this can apply to anyone).
If attraction was as you described, no one would be attracted to anyone outside of pro athletes and supermodels. Clearly, many normal, non-models are quite attracted to their non-model partners.