By far the most important trait is that they know their team and their strengths and weaknesses, put them doing the right tasks for their skillset, and trust them to get the job done.
The second most important trait is a clear vision. They know what they need to achieve, what resources they need and/or have available, and don't waste time on pointless busywork (like scrum poker)
Working with someone like that makes work very rewarding. It is unfortunately almost impossible to find such a leader in most big companies as their company structure with 30 layers and PMs and what not simply does not allow it.
Competent, has solid strategy, can execute it.
I used to work at a summer camp and during meal time, it was easy to tell who the good leaders were.
They weren't the people at the front of the line before their campers. The good leaders made sure their subordinates ate first and they waited to eat last and ate with their campers, rather than the staff table.