I've worked in a pretty wide range of jobs and the conclusions I've come to are:
Any job can be enjoyable (even wiping adults' bums - a job I have done) if it 1) seems like something that actually needs to be done (and those adults definitely needed to have their bums wiped) 2) it garners at least some respect from somebody (even if that somebody is just you) 3) the pay is good enough that you can afford at least some things that aren't basic 4) at least some of the people you work with are people you like and respect 5) you are never made to do anything in your job that seems pointless or goes against your own values 6)You at some point feel a sense of achievement, of a job well done and a goal reached 7) you have enough work to keep you genuinely busy, but not so much that you feel you can never get it done.
I do think it's possible for most people to find a job they really enjoy or even love, but there are two related issues standing in the way of that. 1) the definition of a 'good' job tends to be so narrowly defined and 2) too many people work in jobs that don't suit them and therefore end up making other people's lives miserable by being useless, grumpy, needlessly micromanaging, lazy, unreliable etc etc. In most jobs I've had that have been shit it's been almost entirely down to the other people, people who shouldn't have been in the roles that they had and who as a result made everyone else's life harder.
If you're not sure what job suits you then you have to sit down and be honest about what you really like (forgetting all notions of prestige, pay, what's expected of you etc) and have some imagination about what job might fit with that. If you're doing a job where you feel you're actually making some progress, have some skill and are being challenged (no matter what that job is - it could be painting lines on roads or quality control in a chewing gum factory) you will enjoy it.