I've seen it now and again, or maybe a bit more often than just now and again. But not really a lot of people get like that, but enough of them to be noticeable.

The all-nighters and heroic long hours can sometimes be cured by a bit of help so that the work gets done faster and the long hours aren't needed - and that's sometimes technical help. Some technical people get really hung-up on some of the non-technical aspects of their job, like careeer development planning for their subordinates or mentoring or preparing pitches for potential customers or composing press releases and usually (but not always) that requires a different sort of help.

But don't make the mistake of thinking that all-nighters are always a sign of problems, or long hours (how can long hours be "heroic"?). At one point when very young I preferred to put in my 37.5 hours each week in 3 long shifts instead of 5 short ones, because that gave me two more days at home each week. When I was younger than that I used to prefer working midday to 10pm with a 2 hour early evening break instead of 9 to 5 with a 1 hour lunch break. In both those cases there was no bother from my employer. Later on I occassionally found myself in a situation where working silly hours was a good idea but in compensation when things were quiet I could go and work from home for a couple of weeks or take a few days off altogether without using up any leave time, so working silly hours wasn't a problem.