I always saw archery more as a stealth attack if you're an assassin class character (or a good set up thief) to use from a distance but once the element of surprise was gone it's on to close quarters weaponry.

The only other usable use for archery in Morrowind or Oblivion imho was hunting wildlife that wouldn't fight back.