In some instances, I think it would be nice just to have some kind of leadership at all. The company I currently work for seems to have more emotional "rah-rah go team" kind of leadership than business and decision making leadership. The software product I work on for example, has an elaborate committee of managers to make decisions in a rather long drawn out process (with very little input from our clients) for a project that only has 2 web developers and myself as the lone DBA/database developer. It's often painfull to get anyone to make decisions.

In general though, I think I'd want a balanced leader that was willing to receive conservative and risky advice, and was able to find the right balance between the two.