I still think of Cassandra as the tool the Digg engineers used to kill Digg as we all loved/hated it at it's time.
I agree it wasn't Tech fault for Kevin Rose allowing VCs to control Digg, but there were issues with Cassandra and especially during the SQL vs NoSQL debate at its highest levels.