The often lonely status of the CEO can demand a heavy personal price in meeting the expectations of directors, shareholders, customers, and employees, writes John Daly