That blog was posted 9 years ago. Needless to say, a lot of improvement and engineering has happened since then. The limited use cases of LWTs will soon be replaced with general, ACID transactions.
https://thenewstack.io/an-apache-cassandra-breakthrough-acid...