I think the name of the game your trying to think of is "blood bowl" but it is older and it matches your description.
OK, so a while back I played a really fun demo (imo), and I want to get it, but I have no idea what the game is called.
The game was football with a twist, you could be like orcs/dwarfs/undead/etc and while playing this football game, you could attack (and I think even kill) and use spells and stuff on the other team. I have no idea what catagory it would be in, since you can make your own team member (rpgish) play football (sports) and attack the other team (action).
Does anyone recognize the sound of this game? I think i played it mid 2005, but not for sure

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic