CEOs from Warren Buffett to Jack Welch say the debt ceiling debate is unnecessary. Some are more optimistic than others.