What are the penalties of using many (thousands) of column families or keyspaces in Cassandra?
Cassandra 1.0 uses a minimum of 1MB of heap per CF.  So, 1000 or 2000 CFs will be okay for typical heap sizes, but 10000 will probably not be.  JVM GC does poorly with very large heaps; I recommend staying under 8GB.