If the task is both undesirable, difficult to find people to fill, and yet widely sought after and greatly needed, the word you're looking for is "lucrative."

If the task is both undesirable, difficult to find people to fill, and yet widely sought after and greatly needed, the word you're looking for is "lucrative." Example: plumbers. Excel wizards: quit your whining and go make bank.