The requirements for cloud gaming revolve around having the hardware to drive the local monitor, and having fast enough internet with low enough latency.
For example, here are Geforce Now's minimum requirements: https://www.nvidia.com/en-us/geforce-now/system-reqs/
There is some overhead involved in streaming, but the RAM requirements are low and certainly don't change based on the game.