You have to consider the capabilities in addition to the performance/guarantees trade-off.

A key/value store with SERIALIZABLE transactions isn't as useful as a system that allows multiple-statement transactions but only offers REPEATABLE READ.