An educative and insightful link, thanks to Prathap Suthan.
What actually makes for a great CD and what ideally should his job entail?
There is actually no need for pony tails and tattoos, tantrums are not always a sine qua non and you need not behave like an academically challenged arsehole, spoilt brat, snobbish sadist, puerile prick and an insecure infant all rolled into one, to make the grade :)!
A lot of CD's who are successful, are well behaved, good human beings and end up leading great teams which produce work that is highly rated and well regarded.
http://www.thedenveregotist.com/editorial/2009/march/5/rant-what-makes-good-creative-director-part-1-2