10-15 years ago, Apple had a product built around this concept, the Fusion Drive. It was one physical device containing both types of storage that appeared to the user as a single drive. The OS would decide what files when on which storage medium based on usage. Unfortunately, it’s been long enough that they went to all SSDs all of the time that Apple is removing support for it in this year’s OS release.