It depends on the type of stress too. I've worked in a call centre where there was a constant push to make sales and hit targets, and I'm sure that contributed to my illness. It wasn't enjoyable for most of the time.

On the other hand, I worked in a nightclub, and the weekends were very stressful, but it was an enjoyable stress. I'd be working with a team of my friends, and we knew a significant amount of the regular customers, and for the vast majority of the time everyone was happy. If I was still fit and healthy, and didn't have conflicting responsibilities, I'd do that job again today :)