"For" is the correct collocation for "affection." The only reason "upon" can be used in the example you gave is because "upon" goes with "beam."
In other words, in "he beamed with affection upon his new friend," "affection" is being used in the sense of a ray of light, and "he" is "emitting" the affection (like the sun emits light upon, say, a flower) on his new friend.
Otherwise, I would never say "I have a lot of affection upon you." You should say "I have a lot of affection FOR you."
So think of "upon" as going with "beam," not with "affection."