I also consider this a very pure form of affection, because it usually does represent a sincere desire for another persons happiness over your own.
I disagree, in fact I would call that one of the most selfish and tainted forms of "affection" imaginable because it doesn't display any empathy for how other people
might consider your feelings. Again, this is another problem with the friendzone "narrative". It assumes that all women do not think of you ("socially awkward" male) any more than they think of single-celled protazoa living in their food. It assumes that unless women deign to let you sleep with them you are automatically beneath their notice and of no consequence to them.
This is not true
. In the real world your feelings matter. They matter to more than just you. Looking after them is not just advisable if you want to be functional person, it is also kind of a social responsibility because if you aren't looking after yourself, if you aren't doing what makes you happy, then you are implicitly making it someone else's
responsibility to look after you and make you happy. That is not cool when you are a grown up, it is not going to make it easy for people to treat you with honesty and dignity, and it is certainly
not going to make people want to go to bed with you because really, anyone who has had a bad relationship (i.e. most adult women) can see the impending trainwreck a mile off.
Otherwise, I agree with everything you've said.