I once worked with a very senior creative who was exceptional at his job. We all worked in an office together - this was a few years before the current remote phenomenon had quite the momentum behind it that it now has. He came in at midday, on a good day, and normally stayed late into the evening (I think he enjoyed having a little red wine whilst he was working, which probably slightly stretched the boundaries of acceptability in that office). His work was exceptional - on-brief but always extremely innovative. But, you know, when you actually wanted to schedule a meeting with him to discuss a project, it was always bloody hard work - he collaborated very well with the other members of his team who enjoyed staying late in the evening, but he was a constant thorn in the side of the project managers who often wanted to talk to him in the morning when he was never there.
So, yes - it depends.