Yes, having a manager just be there showing appreciation is huge. My story is trying to crack a hot, high-impact bug that got reported days before product launch. Daily 8:00AM and 5:00PM status meetings on Saturday and Sunday reporting to multiple VP's kind of hot. So the debug lab manager had little clue how to hang a logic analyzer probe any more, and no clue how to read the traces. But he brought in take-out 3 meals a day and did whatever else to keep us well-fed and caffeinated during the ordeal. And if we wanted to consult with somebody, he tracked them down and got them on the phone. Basically just hung out and said "Thanks" often.
That is 100% awesome. I've had a few managers over my career that got that.
The counterpoint (funny enough, at the same company as the ice cream) was a different exec who came close but just missed the mark. Weekday evening deployment (started at 5:30pm) and he orders pizza. A lot of pizza. Things go smoothly and since we're just sitting and watching monitoring for a bit to make sure all is good, he decides to head out. Ten minutes after he leaves, we get a call about a third-party site that broke after the deployment... guess we're not leaving.
So the debugging drags on, and around 11pm we start getting hungry. AHA! Leftover pizza in the fridge! We go to the kitchen to discover... he took all of the leftovers home. Like 4 pizzas worth. So what's our conclusion? "Fuck it, we'll fix it in the morning. Let's go home."