It's not about heroification and myth-making or what you're used to. It's entirely about the excitement found in the chaos, and either you thrive on that, or you hate it... or you get Stockholm Syndrome and learn to love it because of the psychological trauma of running that gauntlet.
It's stressful for sure, in a manner not dissimilar to jumping out of a plane for the first time. The rollercoaster of emotions. The dread and worry about how the fuck you're going to pull off the impossible. The heartbreak you feel as you think you're just not going to be good enough to pull it off this time. The relief when you manage it again. The exhilaration of having come through it, perhaps with some bumps and bruises, but you made it and it didn't kill you.
Work in this kind of environment long enough and it will either break you or make you feel like there's nothing you can't do. One thing's for certain though, it does change you, in a way that those who haven't worked in startups will never quite understand.
Consulting is certainly a different mindset. You can either become attached to the project and make it as much your baby as the rest of the team, or you can function as mentor and help them to grow to the point they can handle it themselves. There's a lot of satisfaction in this. I find that the more emotionally involved I am in a project, the more fulfilling it is. The more detached I remain, the less so. I get a lot of enjoyment about being part of a team coming together for the achievement of a goal - even if that goal is to make someone else rich. When a project is personal, and by personal, I mean I'm emotionally attached to the outcome and I am vested in seeing it succeed, the emotional highs and lows are where the magic is found... that's what makes me feel alive and that is what I live for.