Partition Key selection aside, if you want a better Cassandra, look at ScyllaDB. Much, much better engine, imho.

/disclaimer/ I used to work at Scylla.