I agree with your point after delving into the details about kvm balloon. Currently, no official support for dynamic RAM. On Windows VMs, they do support automatic increase of the RAM. On Linux VMs, they support neither automatic increase nor decrease.