> super high performance tiering RAM+NVMe buffer managers which can access the RAM-cached pages almost as fast as a normal memory access are mostly only detailed and benchmarked in academic papers

Isn't this exactly what modern key value stores like RocksDB, LMDB etc are built for?