Neon does a variant of this. The WAL goes through a Paxos consensus directly on NVMe, which then is transformed to page files and stored in Object Storage
In tiered storage databases individual tables or rows would move automatically and permanently between different mediums according to some criteria. eg: Latency sensitive data on nvme near the user, frequently accessed data stored on nvme and replicated globally, infrequently accessed data stored on spinning disks, etc.