That Venture Hacks article says "One of the founders should be the CEO so you can make decisions quickly."
Anyway, I'm sure it varies. I really am curious what top investors think though. Does Ron Conway think less of you for telling him "I'll be the CEO and he'll be the CTO" assuming you're not arrogant/lame about it?
http://venturehacks.com/articles/top-heavy
http://www.beyondvc.com/2006/06/topheavy_teams.html
I've also heard this in private conversation (specifically, the first time we met with a VC before promptly ditching the titles) and a couple of the speakers at YC in our batch mentioned it.