I have had a very clunky experience historically. But I tried the built in steam game streaming over the local network to my steam deck and this time the experience was flawless.

I feel like the problem is a very large number of rough edges and software bugs, hardware issues, etc. But it's so possible to stream over the local network with zero noticeable latency. Only if all the stars align and there are no bugs.