There's already a spelll to use Tenser's offensively. The only differences are that it's called Mindless Rage, it has a will save, it's only level 2, and it's in Spell Compendium.
(And that was tongue-in-cheek, I realize it's got other differences like being enchantment.)
Enchantment spells are by and large useless, since so many monsters are immune to mind-affecting effects, but I'm really glad I took Mindless Rage. It's shut some bad guys down, and I can certainly take their physical attacks -- assuming they can get past my AC 38.