So the TL;DR is: Cassandra and ScyllaDB have bad performance when reading. So they put a cache in front.
This means we don't have to deal with cache invalidation/consistency issues while also being able to handle thundering herds, for example a large server pinging @everyone and having a bunch of people click into the channel or launch their apps in response.