I tried to come up with something, but I can't. Most of the characters I think of for things are either from games I haven't played and thus don't want to use, or I think of way too many flaws they'd have in that position. I have issues.
The few things I decided on were Alakazam for a brain spot, Altair and Ezio for my agile spots because fuck the police, and GLaDOS for comic relief because I love her cutting sarcasm.
Brains: Isaac Clarke (Dead Space), Kyōko Kirigiri (Danganronpa)
Brawns: Alpha-152 (Dead or Alive), Black Knight (Dark Souls)
Agiles: Ayane (Dead or Alive), Shiranui/Amaterasu (Okami)
Gunners: Master Chief (Halo), White Glint (Armored Core 4a)
Leader: Illusive Man (Mass Effect)
Boss: Ornstein and Smough (Dark Souls)
Comedic Relief: Hazama (Blazblue)
This doesn't work when you're a multiplayer, ARG only person..
Although my comedic relief is Tiny Tina.
Brains: Zhuge Liang (Dynasty Warriors), Darth Revan (KOTOR)
Brawn: Tank (Left 4 Dead 2), Lu Bu (Dynasty Warriors)
Agiles: Batman (Arkham City), ezio auditore di firenze (Assassin's Creed ll)
Gunners: Master Chief (Halo), Marcus Fenix (Gears of War)
Leader: The Lone Wanderer/The Courier (Fallout 3)
Boss: Illusive Man (Mass Effect 2)
Comedic Relief: The Champion of Kirkwall Hawke (Dragon Age 2)
Everything is Anti-Mage with a blink dagger.