First time I read this thread, and I really like it, and I like that something like this is going into the game.
I think that the points in these areas should be public, shown even if stats are hidden to a given person. You know who the team leaders are.
I also think that team leader points need to be cumulative, at least more than in the original post, or then it's a poor choice to make (If you aren't the top on the team, then you only help half as much? That really weakens it. Better to lower the bonus if necessary but allow the second highest one 90%, third highest 80%, etc..)
I'd also love to see more types, too. Three is limiting.
Two other ideas, perhaps:
Trickster: Out for himself and to some degree the team, but not with a work ethic like the Workout Warrior. Questions asked will usually be answered selfishly (e.g. asked to build the home, he won't pick up a hammer or appear in a commercial).
His bonus is that he plays dirty, and as such gains an 0.5% bonus to many physical skills (Namely, Speed, Strength, Agility, and Jumping) per point of Trickster.
When ref-called penalties are added, he's more likely to be called for a penalty, but the bonus becomes 1% or maybe 0.75% instead of 0.5% to balance that out.
Loner (someone else's archetype, tried to be figured in by me): This guy views football as a job like any other. If he had the skill to, he'd just as soon be a doctor or lawyer. He's there to pick up his paycheck, do his job, and go home. He doesn't care so much about his career except to keep cash coming in, or the team's performance.
His bonus is that his morale is close to unshakeable, because he really doesn't care much. Any other benefits of Confidence, he doesn't receive any bonus for; but he loses 5% less per point of Loner in anything that would cost him morale (but also gains 2.5% less per point from anything that would normally help his morale).
Those percentages may need major revisions for balance, but I'm simply trying to add more possibilities.