I have found that melee is pretty pointless in the single player missions as soon as you get to your first real fight with super mutants... I believe it's St. Louis, I may be wrong though. It's the one where you're on a huge battlefield, and you get an APC.
Hand to hand can be fairly useful...