If you pushed a bug to prod, knocked out all of Australia, then went home and aren't answering your phone because it's after hours and you're not on call, I'm not going to be happy with you. (Not that we would normally push to prod right before going home, but to illustrate the point...)
If you work 9-5, M-F, never cause any fires, and hit your milestones, then I'm perfectly satisfied with that.
That's just me, though; I intentionally maintain a relatively balanced workplace. Other companies and managers will have different styles. That being said, don't underestimate the importance of likeability [0]; you'll be fighting against human nature and unconscious biases if you do. How that manifests (general friendliness, going to after-hours social events, helping others with tough tasks, etc) will vary by person and team.
[0]: https://www.wsj.com/articles/why-likability-matters-more-at-...