Tim's a great CEO. In fact, titles aside, he's effectively been in that role since about, oh, 2004. Take it from someone who worked for him for over a decade.
If Apple were any other company, and Steve were any other person, his title would have been "Chief Creative Officer," or something similar.
That's the problem they have no creative vision - no drive. They're just playing catch up. I'm a hard core mac user, but when you have brand loyalists who are saddened by the lack of innovation and drive, which is a key component of the brand, then it starts making it hard to continue your love affair with them. They built their recent brand on impressing consumers, but everything in the last few years has been industry standard wrapped up in a glittery bow. Sure you can impress with a glittery bow for a few seconds, but where's the substance behind it?