Dunno about exploding heads.... unless it was a magical exploding arrow- normal arrows just tend to make nice, linear holes through things. They don't expand and shatter like bullets can. What I would like to be able to do though, along the lines of locational damage, is hit them in the leg, and see them hobble or go down on one knee, and remain hobbled for the rest of the fight. They could swing melee weapons at you (with no power hits) if you got close enough to let them- but that's it. Shoot them in either arm, and it becomes unusable. If they are only equipped with a 2H weap or bow, that's it, they'd have to run or get killed. Headshots would be 50% extra damage. Stuff like that. At least for human enemies, and lower level monsters. Things like giants, draugr deathlords... they'd have to be made of sterner stuff and harder to seriously cripple, or it would be too easy to disable them.
Only if it can happen to the player also. Get shot in the arm, sorry Dragonborn, no more sword for you. It would only be fair, right? Or are people going to cry that if they get shot in the leg they can't run anymore?

But more seriously: no, I would not want exploding heads with archery.