Agreed, this is something that takes a little getting used to.
Diagrams help: http://www.datastax.com/docs/1.0/ddl/index
Max's posts also include some good examples, although they predate some features like column indexes: http://maxgrinev.com/2010/07/12/do-you-really-need-sql-to-do...
I would like to see some more example data models and deployments on Cassandra because I still find the column model entirely unintuitive but that is more a limitation of my brain as obviously people are deploying on it just fine.