I can only comment from the engineering side, since that’s where I work: we are working on increasing storage capacity more. I am not aware of any plans to decrease the cost.
I think it should be accessible to Motoko using the low-level API that works directly with the stable memory. Here is the Motoko-specific discussion: Motoko stable memory in 2022