It's easy to idolize famous CEOs and admire their drive to innovate. But some have gone way off course.