I can enjoy even menial work if I'm surrounded by friendly people who like doing a good job.
I can loathe any work if I have to deal with unqualified, socially combative, or unnecessarily difficult coworkers.
The job also needs to be focused on delivering the product, not constantly fighting corporate dysfunction, attending meetings, and jumping through managerial hoops.