Since, at present, I have to have a job, I'm very glad with the one I've got! In generally, I really like it, and am very grateful for it.
I've been at the same place for 10 years though, and it hasn't always been this way. I HATED my job, wanted to quit, considered quitting every Sunday night for a long time. What changed isn't the actual work I do (the executable work I mean, I enjoy that), but previously I had to manage people. I hated it. But with the level of responsibility and pay I had, there was no choice.
Unfortunately the company downsized, but fortunately for me, I retained my pay and position without having any direct reports. This changed my working environment completely, I just have to do the work I enjoy now, with no-one to manage. And that's why I love my job.
So I would say the actual work is important, but how you are spending the majority of your time is more important. I just didn't enjoy telling people what to do (ironic, I know, I love to boss people around on the forums), and I didn't like having to lead by example. Now I can leave early if the work is done, without worrying about 'how it looks'. Flexible hours (ie only working when there is work to be done, not playing 'who can stay the latest') and autonomy are the most important things to me.