Inflicting damage on an unconscious target does not revive them, that's for sure.
Sleeping creatures - as in normal slumber, are automatically awakened by damage.
Creatures affected by a magical Sleep effect are knocked unconscious and rendered helpless. They do NOT wake up when damaged, unless the power specifically states this.
For the Come and Get It power, I wouldn't allow it, as a DM. The bad guys are unconscious you say (and therefore I assume they are not 'sleeping normally'). While unconscious and helpless, you cannot take actions, grant CA, have a -5 to all defenses, and more. That's per the specific rules regarding Helpless and Unconscious status effects. No getting up from prone, no move actions, no free actions, nothing. Ergo you don't wander over to the fighter to be slaughtered - the lazy fighter has to walk over and do his own slaughtering.
Inspiring Word, used on an unconscious ally, does work, because the general rule on healing unconscious charactes applies, and nothing is specifically given in any of the three areas (the power, unconscious, helpless) that would preclude it.