Turns out a sata storage controller can do that too, Microsoft has been adding support for that too.

GPU decompression is also a thing though, so compression is still a way to save I/O.

Interesting. How modern are we talking here? Is this a "devil's in the details" kind-of feature?

drives since 2018 or so

it's marketed by Microsoft as "direct storage"