Calling yourself CEO in a 2 person company is a common enough faux pax that I've seen it mentioned in several investors' blogs and it's one of the things they sit around and make jokes about when the startup's back is turned.
"If you don't have anyone on your founding team who is capable of being CEO, then sell your company -- now." -- Marc Andreessen
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.
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?
Co-founder seems universally safer.