Stubbs the Zombie.
Seconded. If nothing else, it's a fun game.
Thirded. Its also hilarious.
I started to get worried when five posts had gone by without this getting mentioned. It's loads of fun, and it actually has reanimation as a central game aspect, rather than merely a theme.
Plus, y'know, ripping out one of your own organs and using it as an explosive zombifying grenade to destroy a jetpack-wearing barbershop quartet member is one of those things you really just can't pass by.
Sacrifice has this to a mild extent, where you summon forth magical servants to reanimate, paralyze, and then ritually sacrifice the deceased minions of your enemies. This grants you the use of their souls, which you can then create your own army with.
Diablo II includes a Necromancer class that can rip forth the bones of their conquered foes in order to form a skeletal army. At higher levels they can also just reanimate the critters as they are, but this only lasts for a few minutes. The skeletons stick with you until they die (which may, incidentally, take less than a few minutes).
The Dungeon Keeper series allows you to starve captured foes to death in a prison, whereupon they will turn into skeletons to fight for you. You can also collect rotting corpses from the battlefield to stockpile in your graveyards, which can call forth vampires.
I'm sure I've played some other titles that let you put the dead to use, but nothing else is coming to mind at the moment. I mean, there's also The Hidden mod for HL2, which lets you "eat" dead players, but it's basically just you stabbing some ragdoll with a knife and getting healthpoints for the trouble.