We long to land our dream jobs, expecting excitement, fulfillment and fun. But these glamorous positions can turn out to be more drudgery than employees imagine.