I'm a bit meh about holidays. Some times when work is crazy stressful, to the point where weekends aren't enough to unwind, then they're a necessity. But I wouldn't call that enjoyment - more a sun fix.
There's something about dumping me in an unfamiliar location for a couple of weeks that I find slightly depressing. You never get beneath the surface of the place, and see it on a relatively superficial level. Feels like a short term sugar fix. Lost In Translation summed that vibe up really well.
In an ideal world I'd have the luxury of taking a couple of months off every year and transplant myself somewhere and see what happens. My motivation is usually to make friends and meet interesting people rather than sightsee. Sightseeing is boring!