What leadership profiles generally align with the modern workplace’s emphasis on knowledge, skills and capabilities?

What leadership profiles generally align with the modern workplace’s emphasis on knowledge, skills and capabilities? What previous experiences and education boost the effectiveness of successful HR managers? What red flags would indicate that a potential hire as an HR director would not bring the skills and capabilities needed to an organization?